求JSP SQL数据库链接代码及增删改查的代码

求JSP SQL数据库链接代码及增删改查的代码

package s2.jsp.dao;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;public class BaseDao {
public final static String DRIVER = "com.microsoft.sqlserver.jdbc.SQLServerDriver"; // 数据库驱动 public final static String URL = "jdbc:sqlserver://localhost:1433;DataBaseName=Messages"; // URL public final static String DBNAME = "sa"; // 数据库用户名 public final static String DBPASS = "sa"; // 数据库密码 private Connection conn = null; private PreparedStatement pstmt = null;

public Connection getConn() throws ClassNotFoundException, SQLException {
Class.forName(DRIVER); // 注册驱动
Connection conn = DriverManager.getConnection(URL, DBNAME, DBPASS);
// System.out.println("DB success connection");
return conn;
} public void closeConn(Connection conn) {
// 如果conn不空，关闭conn
if (conn != null) {
try {
conn.close();
} catch (SQLException e) {
System.out.println("关闭数据库连接时出错！" + e.getMessage());
}
}
} public void closePstmt(PreparedStatement pstmt) {
// 如果pstmt不空，关闭pstmt
if (pstmt != null) {
try {
pstmt.close();
} catch (SQLException e) {
System.out.println("关闭执行对象时出错！" + e.getMessage());
}
}
} public void closeRs(ResultSet rs) {
// 如果rs不空，关闭rs
if (rs != null) {
try {
rs.close();
} catch (SQLException e) {
System.out.println("关闭结果集时出错！" + e.getMessage());
}
}
}


public void closeAll(Connection conn, PreparedStatement pstmt, ResultSet rs) {
closeConn(conn);
closePstmt(pstmt);
closeRs(rs);
}
public int executeSQL(String preparedSql, String[] param) {
int num = 0;
// 处理SQL，执行SQL
try {
conn = getConn(); // 获得数据库连接
pstmt = conn.prepareStatement(preparedSql);
if (param != null) {
for (int i = 0; i < param.length; i++) {
pstmt.setString(i + 1, param[i]); // 设置参数
}
}
num = pstmt.executeUpdate(); // 执行SQL语句
} catch (ClassNotFoundException e) {
e.printStackTrace(); // 处理ClassNotFoundException异常
} catch (SQLException e) {
e.printStackTrace(); // 处理SQLException异常
} finally {
closeAll(conn, pstmt, null);
}
return num;
}}

如以上回答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！

点此我要举报以上问答信息