import java.sql.*;
public class preparedStatementTest {
public static void main(String[] args) {
Connection con = null;
ResultSet rs = null;
PreparedStatement ps = null;
try {
SqlConnectionHelp.driver();
con = SqlConnectionHelp.getConnection();
if (con == null)
return;
String sql = "insert into member values(?,?,?,?,?)";
ps = con.prepareStatement(sql);
ps.setInt(1, 4);
ps.setString(2, "xiao");
ps.setString(3, "19870210");
ps.setInt(4, 25);
ps.setString(5, "7777777");
ps.addBatch();
ps.setInt(1, 5);
ps.setString(2, "xiao");
ps.setString(3, "19870210");
ps.setInt(4, 25);
ps.setString(5, "7777777");
ps.addBatch();
ps.executeBatch();
//System.out.println("恭喜你,成功插入了" + count + "条记录!");
//count = ps.executeUpdate("update member set age=age+1");
//System.out.println("恭喜你,成功更新了" + count + "条记录!");
SqlConnectionHelp.release(ps);
String sqll = "select *from member";
ps = con.prepareStatement(sqll);
rs = ps.executeQuery();
System.out.println("******************************");
System.out.println("会员ID/t姓名/t密码/t年龄/tOICQ号");
while (rs.next()) { //从结果集中获取每个列中的值
int id = rs.getInt(1); //获取当前记录中第1列内容
String userName = rs.getString(2);//获取当前记录中第2列内容
String passWord = rs.getString(3);//获取当前记录中第3列内容
int age = rs.getInt(4); //获取当前记录中第4列内容
String oicq = rs.getString(5); //获取当前记录中第5列内容
System.out.println(id + "/t" + userName + "/t" + passWord
+ "/t" + age + "/t" + oicq);
}
} catch (Exception e) {
e.printStackTrace();
} finally {
SqlConnectionHelp.release(rs, ps, con);
}
}
}
import java.sql.*;
public class SqlConnectionHelp {
public static void driver() {
String s = "com.mysql.jdbc.Driver";
try {
Class.forName(s);
} catch (Exception e) {
e.printStackTrace();
}
}
/***
* 连接数据库的方法
* @return 返回数据库连接的对象
*/
public static Connection getConnection() {
String url="jdbc:mysql://localhost:3306/jdbc";
Connection con = null;
String userName = "root";
String passWord = "123456";
try {
con = DriverManager.getConnection(url, userName, passWord);
} catch (Exception e) {
e.printStackTrace();
}
return con;
}
/***
* 释放数据库资源
* @param rs 结果集对象
* @param stmt 编译语句对象
* @param con 数据库连接对象
*/
//释放数据库资源
public static void release(ResultSet rs, Statement stmt, Connection con) {
try {
if (rs != null)
rs.close(); // 关闭结果集
} catch (Exception ee) {
ee.printStackTrace();
}
try {
if (stmt != null)
stmt.close();// 关闭编译语句
} catch (Exception ee) {
ee.printStackTrace();
}
try {
if (con != null)
con.close();// 关闭数据库连接
} catch (Exception ee) {
ee.printStackTrace();
}
}
/***
* 重载 releaser方法
* @param o
*/
public static void release(Object o){
try{
if(o instanceof ResultSet){
((ResultSet)(o)).close();
}else if(o instanceof Statement){
((Statement)o).close();
}else if(o instanceof Connection){
((Connection)o).close();
}
}catch(Exception e){
e.printStackTrace();
}
}
}