【Java开源代码栏目提醒】:网学会员Java开源代码为您提供conn.java参考,解决您在conn.java学习中工作中的难题,参考学习。
package news;
import java.sql.*;
public class conn {
String sDBDriver = "org.gjt.mm.mysql.Driver"; //璁剧疆JDBC椹卞姩绫诲瀷
String sConnStr = "jdbc:mysql://localhost/test"; //璁剧疆杩炴帴鏁版嵁搴撴湇鍔″櫒瀛楃涓?
Connection connect = null;
ResultSet rs = null;
public conn() {
try {
Class.forName(sDBDriver);
}
catch(java.lang.ClassNotFoundException e) {
System.err.println( e.getMessage());
}
}
public ResultSet executeQuery(String sql) {
try {
connect = DriverManager.getConnection(sConnStr,"root","zgy01"); //寤虹珛杩炴帴
Statement stmt = connect.createStatement();
rs = stmt.executeQuery(sql); //鎵ц鏁版嵁鏌ヨ璇彞
}
catch(SQLException ex) {
System.err.println(ex.getMessage());
}
return rs;
}
public int executeUpdate(String sql) {
int result = 0;
try {
connect = DriverManager.getConnection(sConnStr,"root","zgy01");
Statement stmt = connect.createStatement();
result = stmt.executeUpdate(sql); //鎵ц鏁版嵁鎿嶄綔璇彞
}
catch(SQLException ex) {
System.err.println(ex.getMessage());
}
return result;
}
public void close(){
if(connect!=null){
try{
connect.close(); //鍏抽棴杩炴帴銆侀噴鏀捐祫婧?
connect = null;
}catch(SQLException ex) {
System.err.println(ex.getMessage());
}
}
}
}
上一篇:
Conmessage.java
下一篇:
法律专业开题报告范文