String strDriver="org.gjt.mm.mysql.Driver";
String strConn="jdbc:mysql://localhost:3306/forum?user=dylanwolf&password=760726";
private Connection conn = null;
private Statement stmt = null;
ResultSet rs = null;try {
Class.forName(strDriver).newInstance();
} catch (Exception E) {
System.err.println("²»ÄÜÁ¬½ÓMySqlÊý¾Ý¿â£¡");
}
}
ResultSet rs = null;
try {
conn = DriverManager.getConnection(strConn);
stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs = stmt.executeQuery(sql);
}catch(SQLException ex) {
System.err.println("Ö´ÐÐSQLÓï¾ä³ö´í£º" + ex.getMessage());
}
while(rs.next())
{
out.println("<LI>rs.getString()</LI>")
...
}
String strConn="jdbc:mysql://localhost:3306/forum?user=dylanwolf&password=760726";
private Connection conn = null;
private Statement stmt = null;
ResultSet rs = null;try {
Class.forName(strDriver).newInstance();
} catch (Exception E) {
System.err.println("²»ÄÜÁ¬½ÓMySqlÊý¾Ý¿â£¡");
}
}
ResultSet rs = null;
try {
conn = DriverManager.getConnection(strConn);
stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs = stmt.executeQuery(sql);
}catch(SQLException ex) {
System.err.println("Ö´ÐÐSQLÓï¾ä³ö´í£º" + ex.getMessage());
}
while(rs.next())
{
out.println("<LI>rs.getString()</LI>")
...
}
解决方案 »
- 跪求java大神 急!!!spring security 跟 shiro 问题
- proxool链接远程数据库?
- 发布新闻如何将新闻标题显示在指定的栏目里?
- 北大青鸟ACCP4.0
- ireport设计
- 为什么文章显示出来之后,表格都变宽了?
- 关于 SmartUpload 上传时遇到的中文问题(Linux下),望穿高手指点?
- 请问怎样在页面直接快速画图,能否给个例子,谢谢
- 求问,用struts从jsp向action传递一个list数据
- select otion 联动后放到第二个select option 里
- 請教高手 : 如何實現一個 JDBC 的連結池 ?
- JAVA或JSP有可能与VB通信吗???
String address = "jdbc:microsoft:sqlserver://192.168.7.6:1433";
/***user: 数据库用户名*/
String user="sa";
/**passwd: 用户密码*/
String passwd="";
/*数据库名*/
String database = "DMCADSQL"; DatabaseMetaData conMD = null;
java.sql.Statement stmt = null;
Connection con = null;
ResultSet sqlRst = null;
// try
// {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
con = DriverManager.getConnection(address,user,passwd); conMD = con.getMetaData();
con.setCatalog(database);
stmt = con.createStatement();
// }catch(Exception fs) {
// out.print("Connection ERROR</p> <br>");
// }
// out.print("Connection</p> <br>"); try
{
stmt=con.createStatement();
sqlRst = stmt.executeQuery("select drawing_code,version,file_name from drawing");
out.print("stmt OK");
}catch(Exception gr)
{
out.print("stmt ERROR");
}