1.连接数据库代码:
package struts2.demo.dbconn;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import com.mysql.jdbc.Connection;
import com.mysql.jdbc.PreparedStatement;
public class dbBean {
public Connection conn = null ;
public PreparedStatement pstm = null;
public ResultSet rs;
public Connection getConn() {
return conn;
}
public void setConn(Connection conn) {
this.conn = conn;
}
public PreparedStatement getPstm() {
return pstm;
}
public void setPstm(PreparedStatement pstm) {
this.pstm = pstm;
}
//建立数据库连接
public Connection getConnection() throws SQLException, ClassNotFoundException{
String url = "jdbc:mysql://localhost:3306/struts_demo";
String name = "root";
String password = "root";
//加载JDBC驱动
Class.forName("com.mysql.jdbc.Driver");
//建立连接
conn = (Connection) DriverManager.getConnection(url, name, password);
return conn;
}
//查询操作
public ResultSet executeQuery(String sql) throws ClassNotFoundException, SQLException{
conn = getConnection() ;
try {
pstm = (PreparedStatement) conn.prepareStatement(sql);
rs = pstm.executeQuery(sql);
} catch (SQLException e) {
System.out.println("查询失败");
}
return rs;
}
}