首先创建数据库帮助类DBHelper.java
import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
public class DBHelper {
public static final String url = "jdbc:mysql://127.0.0.1/stuinfo";
public static final String name = "com.mysql.jdbc.Driver";
public static final String user = "root";
public static final String password = "1234";
public Connection conn = null;
public PreparedStatement pst = null;
public DBHelper(String sql){
try{
Class.forName(name);
conn = DriverManager.getConnection(url, user, password);
pst = conn.prepareStatement(sql);
}catch(Exception e){
e.printStackTrace();
}
}
public void close(){
try{
this.conn.close();
this.pst.close();
}catch(SQLException e){
e.printStackTrace();
}
}
}
接下来是使用的例子 Demo.java
import java.sql.ResultSet;
import java.sql.SQLException;
public class Demo {
static String sql =null;
static DBHelper db1 = null;
static ResultSet ret = null;
public static void main(String[] args) {
sql = "select * from stu";
db1 = new DBHelper(sql);
try{
ret = db1.pst.executeQuery();
while(ret.next()){
String uid = ret.getString(1);
String ufname = ret.getString(2);
String ulname = ret.getString(3);
String udate = ret.getString(4);
System.out.println(uid + "\t" + ufname + "\t" + ulname +"\t"+udate);
}
ret.close();
db1.close();
}catch(SQLException e){
e.printStackTrace();
}
}
}
运行结果
MySql需要特定的驱动
把那个jar添加到Reference Libraries里即可