首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > JAVA > J2SE开发 >

java链接数据库有关问题

2012-09-10 
java链接数据库问题package com.yzwimport java.sql.Connectionimport java.sql.DriverManagerimport j

java链接数据库问题
package com.yzw;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class test_1 {

public static void main(String[] args) throws Exception {
Class.forName("com.mysql.jdbc.Driver");
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","root");
Statement stmt = conn.createStatement();
/*stmt.executeUpdate("insert into t_user values(null,'wenqi','888888')");*/
ResultSet rs = stmt.executeQuery("select * from t_user");
 
System.out.println(rs.getString(1)+" "+rs.getString(2)+" "+rs.getString(3));
rs.next();
rs.close();
stmt.close();
conn.close();
}

}


运行报异常,不知道为什么。求解。JDBC感觉就是学不好,只有去硬记。

[解决办法]

Java code
package com.yzw;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.Statement;public class test_1 {public static void main(String[] args) throws Exception {Class.forName("com.mysql.jdbc.Driver");Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","root");Statement stmt = conn.createStatement();/*stmt.executeUpdate("insert into t_user values(null,'wenqi','888888')");*/ResultSet rs = stmt.executeQuery("select * from t_user");  try {            while (rs.next()) {                System.out.println(rs.getString(1)+" "+rs.getString(2)+" "+rs.getString(3));            }        } catch (SQLException e) {            e.printStackTrace();        }rs.close();stmt.close();conn.close();} 

热点排行