jsp中连接mysql的javabean

最新推荐文章于 2025-08-08 12:35:56 发布

原创最新推荐文章于 2025-08-08 12:35:56 发布 · 696 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#mysql #jsp #string #sql #null #scroll

jsp源码专栏收录该内容

5 篇文章

订阅专栏

本文提供了一个使用 Java 进行 MySQL 数据库操作的示例代码，包括连接数据库、执行插入、查询、删除和更新操作的方法，并展示了如何关闭数据库连接。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

package connmysql;
import java.sql.*;
public class mysqlconn {
String sDBDriver = "com.mysql.jdbc.Driver";
String sConnStr = "jdbc:mysql://localhost/numb1?user=root&password=1985118&useUnicode=true&characterEncoding=GB2312";
Connection conn = null;
ResultSet rs = null;
public mysqlconn() {
try {
Class.forName(sDBDriver);
}
catch(java.lang.ClassNotFoundException e) {
System.err.println("conn(): " + e.getMessage());
}
}
public void executeInsert(String sql)
{
try
  {
  conn=DriverManager.getConnection(sConnStr);
  Statement stmt=conn.createStatement();

  int n=stmt.executeUpdate(sql);
  }
  catch(SQLException ex)
  {
   System.err.println("conn.executeUpdate:"+ ex.getMessage());
  }
}
public ResultSet executeQuery(String sql) {
rs = null;
try {
conn = DriverManager.getConnection(sConnStr);
Statement stmt;
stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
rs = stmt.executeQuery(sql);
}
catch(SQLException ex) {
System.err.println("conn.executeQuery: " + ex.getMessage());
}
return rs;
}
public void executeDelete(String sql)
{
try
  {
  conn=DriverManager.getConnection(sConnStr);
  Statement stmt=conn.createStatement();
  stmt.executeUpdate(sql);
  }
  catch(SQLException ex)
  {
   System.err.println("conn.executeDelete: "+ ex.getMessage());
  }
}
public int executeUpdate(String sql)
{
     int n=0;
try
  {
  conn=DriverManager.getConnection(sConnStr);
  Statement stmt=conn.createStatement();

  n=stmt.executeUpdate(sql);
  }
  catch(SQLException ex)
  {
   System.err.println("conn.executeDelete: "+ ex.getMessage());
  }
  return n;
}
public void Close()
   {
    try{
       if(rs!=null)
       {
          rs.close();
       }
       if(conn!=null)
       {
          conn.close();
        }
       }
       catch(SQLException ex)
  {
   System.err.println("conn.executeDelete: "+ ex.getMessage());
  }

}
}