Question

java JDBC 连接问题？

Answer 1

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

public class InitDB {
private String DBdriver = "com.mysql.jdbc.Driver";
private String database = "zhuce";
private String url = "jdbc:mysql://localhost:3306/" + database
+ "?useUnicode=true&characterEncoding=utf8";
private String user = "root";
private String pwd = "root";
private Connection conn = null;
private Statement stmt = null;
private ResultSet rs = null;
private static final InitDB initDB_obj = new InitDB();

private InitDB() {
try {
Class.forName(DBdriver);
conn = DriverManager.getConnection(url, user, pwd);
stmt = conn.createStatement();
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}

}

public static InitDB getInitDB() {
return initDB_obj;
}

public Connection getConnection() {
return conn;

}

public Statement getStatement() {
return stmt;

}

public ResultSet getResultSet(String sql) {
if (sql.toLowerCase().indexOf("select") != -1) {
try {
rs = stmt.executeQuery(sql);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return rs;
} else {
return null;
}

}

public void closeDB() {
try {
rs.close();
stmt.close();
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}

}

}
这是数据库的连接~要调用的话还得写调用方法

Answer 2

JDBC五部曲
1.加载驱动
2.获得链接
3.获取statement对象
4.产生resultset对象
5.关闭链接

Answer 3

引入jar包，通过驱动获取连接，得到statement对象，产生resultset对象，调用execute方法执行sql语句

Answer 4

你可不可以把你的问题说的详细点啊？这样都不知道该怎么回答你。。。。。。

Answer 5

什么问题?