javaÐÂÊÖ£¬Çë½Ì¸÷λǰ±²¡£
String sql="SELECT isuuestatus from pts_t_testrecord where recordid="+RecordID;
ÔõôִÐÐÕâÒ»¶Îsql ´úÂë ²¢ÇÒ·µ»Ø²éѯµ½µÄÖµ £¨²éѯ³öÀ´µÄÖµÊÇÖÐÎÄ£©
×Ô¼º¿´¿´ÏÂÃæµÄ´úÂë°É
import java.sql.*;
public class TestMySqlConnect {
public static void main(String[] args) {
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
try {
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager
.getConnection("jdbc:mysql://localhost/mydata?user=root&password=6656565");
stmt = conn.createStatement();
rs = stmt.executeQuery("select * from dept");
while (rs.next()) {
System.out.println(rs.getString("deptno"));
}
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
} finally {
try {
if (conn != null) {
conn.close();conn = null;
}
if (stmt != null) {
stmt.close();stmt = null;
}
if (rs != null) {
rs.close();rs = null;
}
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
¸ãЦ£¬ÓÃÊý¾Ý¿âÁ¬ÓõÄʲôÊý¾Ý¿â¶¼²»Ëµ£¡
¹ûÈ»ÊÇÐÂÊÖ¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡
Ïà¹ØÎÊ´ð£º
µ±ÖªµÀÒ»¸öÈÕÆÚ£¬ÈçºÎ°ÑÕâ¸öÈÕÆÚËùÔÚÑ®µÄǰºóÁ½¸öÈÕÆÚÈ¡³ö
±ÈÈçÊäÈë20090905£¬¾ÍÊäÈë20090901 20090910
Êä³ö20090901 20090910
È¡µÃÌìÊýºó×÷Ò»ÏÂÅжÏÔÙ°ÑÕâ¸ö·½·¨ÓÃÏÂvoid set(int field, int value)
......
ÔõôÔÚ¿ØÖÆÌ¨ÖÐÊäÈëÀàËÆÏÂÃæµÄÐÅÏ¢£º
s1234 50
s1235 80
s1234 90
s1234 40
s1236 90
ÿµ±»Ø³µÊ± ......
ÎÒÊǸöÐÂÊÖ£¬×öÒ»¸öJSPÍøÒ³£¬ÎÒÒª¶Á³öÊý¾Ý¿âÕý³££¬µ«ÊÇÎÒÒªÐ޸ĵÄʱºò£¬Ò²¾ÍÊǶÁÈëµÄʱºò³öÏÖÂÒÂ룬Çë¸ßÊÖ¸æËßÎÒÔõô½â¾ö£¬ÏÈллÁË¡£
request.setCharacterEncoding("UTF-8");
°Ñ±àÂëͳһ
/**
......