getdata.java

来自「linux+apache+tomcat+mysq1+jsp开发的管理系统」· Java 代码 · 共 52 行

package com.javaBean;

import java.sql.*;

public class getData {
public Connection con = null;
public Statement stmt = null;
public ResultSet rs = null;
public getData() {
try {
Class.forName("com.mysql.jdbc.Driver");
}
catch(java.lang.ClassNotFoundException e) {
System.err.println("getData(): " + e.getMessage());
}
}
public ResultSet executeQuery(String sql, String add) {
rs = null;
try {
con = DriverManager.getConnection(add);
stmt = con.createStatement();
rs = stmt.executeQuery(sql);
}
catch(SQLException ex) {
System.err.println("getData.executeQuery: " + ex.getMessage());
}
return rs;
}
public void executeUpdate(String sql,String add) {
try {
con = DriverManager.getConnection(add);
Statement stmt = con.createStatement();
stmt.executeUpdate(sql);
}
catch(SQLException ex) {
System.err.println("getData.executeUpdate: " + ex.getMessage());
}
}
public void close()
{
try
{
stmt.close();
con.close();
}
catch (SQLException ex)
{
	System.err.println("getData.colse: " + ex.getMessage());
}
}
}