JDBC连接mysql数据库

来源：互联网发布：mac打开照片编辑：程序博客网时间：2024/06/08 08:53

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;}}

0 0