statistic.java

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

package com.javaBean;

import java.sql.*;

public class statistic {
Connection con = null;
Statement stmt = null;
ResultSet rs = null;
public statistic() {
try {
Class.forName("com.mysql.jdbc.Driver");
}
catch(java.lang.ClassNotFoundException e) {
System.err.println("mystatistic(): " + e.getMessage());
}
}
public ResultSet executeQuery(String sql) {
rs = null;
try {
con = DriverManager.getConnection("jdbc:mysql://localhost:3306/managedb?user=root&password=123123&useUnicode=true");
stmt = con.createStatement();
rs = stmt.executeQuery(sql);
}
catch(SQLException ex) {
System.err.println("statistic.executeQuery: " + ex.getMessage());
}
return rs;
}
public void executeUpdate(String sql) {
try {
con = DriverManager.getConnection("jdbc:mysql://localhost:3306/managedb?user=root&password=123123&useUnicode=true");
Statement stmt = con.createStatement();
stmt.executeUpdate(sql);
}
catch(SQLException ex) {
System.err.println("statistic.executeUpdate: " + ex.getMessage());
}
}
public void close()
{
try
{
con.close();
stmt.close();
}
catch (SQLException sqle)
{
	System.out.println("sqle=" + sqle);
}
}
}