sql_data.java

来自「基于jsp+javabean+tomcat+eclipse+SQLServer2」· Java 代码 · 共 61 行

package bean;
import java.sql.*;
public class sql_data {
        String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
        String sConnStr = "jdbc:odbc:TSR";
        Connection conn = null;
        ResultSet rs = null;
        public sql_data()
        {
                try
                {
                        Class.forName(sDBDriver);//加载驱动程序
                }
                catch(java.lang.ClassNotFoundException e)
                {
                        System.err.println("sql_data(): " + e.getMessage());
                }
        }
        public void executeInsert(String sql)
        {
                try
                {
                        conn = DriverManager.getConnection(sConnStr);//建立与数据库的连接
                        Statement stmt = conn.createStatement();//创建Statement对象
                        stmt.executeUpdate(sql);//执行SQL语句
                }
                catch(SQLException ex)
                {
                        System.err.println("sql_data.executeUpdate:"+ex.getMessage());
                }
        }
        public ResultSet executeQuery(String sql)
        {
                rs = null;//定义结果集
                try
                {
                        conn = DriverManager.getConnection(sConnStr);
                        Statement stmt = conn.createStatement();
                        rs = stmt.executeQuery(sql);
                }
                catch(SQLException ex)
                {
                System.err.println("sql_data.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("sql_data.executeDelete:"+ex.getMessage());
                }
        }
}