【Java开源代码栏目提醒】:网学会员鉴于大家对Java开源代码十分关注,论文会员在此为大家搜集整理了“VoteConn.java”一文,供大家参考学习
package ch9;
import java.sql.*;
public class VoteConn {
String dbUrl = "jdbc:mysql://localhost/csnews";
String dbUser = "root";
String dbPassword = "";
Connection connect = null;
ResultSet rs = null;
public VoteConn() {
try {
Class.forName("org.gjt.mm.
mysql.Driver");
}
catch(java.lang.ClassNotFoundException e) {
System.err.println( e.getMessage());
}
}
public ResultSet executeQuery(String sql) {
try {
connect = DriverManager.getConnection(dbUrl,dbUser,dbPass
word);
Statement stm = connect.createStatement();
rs = stm.executeQuery(
sql);
}
catch(SQLException ex) {
System.err.println(ex.getMessage());
}
return rs;
}
public int executeUpdate(String sql) {
int result = 0;
try {
connect = DriverManager.getConnection(dbUrl,dbUser,dbPassword);
Statement stmt = connect.createStatement();
result = stmt.executeUpdate(sql);
}
catch(SQLException ex) {
System.err.println(ex.getMessage());
}
return result;
}
}