importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.PreparedStatement;importjava.sql.ResultSet;importjava.sql.SQLException;publicclassstudent{//连接数据...
import java.sql.Connection;import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class student
{
//连接数据库
private String driver = "com.mysql.jdbc.Driver";
private String url ="jdbc:mysql://localhost:3306/student";
private String username ="root";
private String password = "root";
//操作数据库
private Connection conn = null;
private PreparedStatement ps= null;
private ResultSet rs = null;
public ResultSet queryResult(String sql,String []params){
try{
Class.forName(driver);
conn = DriverManager.getConnection(url,username,password);
ps= conn.prepareStatement(sql);
//循环遍历参数集合
for(int i = 0;i
{
ps.setString(i+1,params[i]);
}
rs = ps.executeQuery();
}catch(SQLException e){
e.printStackTrace();
}catch(ClassNotFoundException e)
{
e.printStackTrace();
}finally{
}
return rs;
}
//执行增加、修改、删除语句方法
public boolean isUpdate(String sql,String[]params){
boolean b = true;
try {
Class.forName(driver);
try {
conn = DriverManager.getConnection(url,username,password);
ps = conn.prepareStatement(sql);
//循环遍历参数集合,填补SQL语句中信息
for(int i = 0 ;i
ps.setString(i + 1,params[i]);
}
//执行操作,并获取受影响的行数
int i = ps.executeUpdate();
if(i != 1){
b = false;
}else{
b = true;
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return b;
}
public void close() {
//释放资源
try {
if(rs != null){
rs.close();
rs = null;
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
try {
if(ps != null){
ps.close();
ps = null;
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
try {
if(conn != null){
conn.close();
conn = null;
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
展开