sql_data.java.bak

来自「新闻发布系统1.0 第一步：解开压缩包」· BAK 代码 · 共 74 行

//sql_data.java
package news;
import java.sql.*;
public class sql_data{
String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
 String sConnStr = "jdbc:odbc:news";
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();
stmt.executeUpdate(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 executeUpdate(String sql) {
    Statement stmt = null;
    ResultSet rs=null;
    try {
    conn = DriverManager.getConnection(sConnStr); 
    stmt = conn.createStatement();
    stmt.executeQuery(sql);
    stmt.close();
    conn.close();
    } 
    catch(SQLException ex) { 
      System.err.println("aq.executeQuery: " + ex.getMessage());
    }
  }
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());
}
}
}