src/db/db.java

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

package db;
import java.sql.*;
public class db {
//	private String dbDriver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
	
	// private String sConnStr = "jdbc:microsoft:sqlserver://localhost:1433;databasename=jspjiazheng"; 
	private String dbDriver="com.mysql.jdbc.Driver" ;  
	private String sConnStr ="jdbc:mysql://localhost:3306/jspjiazheng?useUnicode=true&characterEncoding=gb2312" ;
	  public Connection connect=null;
	  public ResultSet rs=null;
	  public db() {
	    try {
	     
	     // Class.forName(dbDriver).newInstance(); 
	     
	    //  connect = DriverManager.getConnection(sConnStr,"sa","123"); 
	    	
			Class.forName(dbDriver).newInstance() ;	
	        connect = DriverManager.getConnection(sConnStr,"root","root"); 
	        System.out.println("连接成功！");
	     
	    }
	    catch (Exception ex) {
	      System.out.println("12121");
	    }
	  }
	
	  
	  public ResultSet executeQuery(String sql) {
			try{
			//	connect=DriverManager.getConnection(sConnStr,"sa","123");
				connect=DriverManager.getConnection(sConnStr,"root","root");
				Statement stmt=connect.createStatement();
				rs=stmt.executeQuery(sql);
			}catch(SQLException ex){
				System.err.println(ex.getMessage());
			}
			return rs;
		}
	  public void executeUpdate(String sql)
	    {
	    	
	    	Statement stmt=null;
	    	rs=null;
	    	try
	    	{   
	    		//connect=DriverManager.getConnection(sConnStr,"sa","123");
	    		connect=DriverManager.getConnection(sConnStr,"root","root");
	    		stmt=connect.createStatement();
	    		stmt.executeUpdate(sql);
	    		stmt.close();
	    		connect.close();
	    		
	    	
	    	}
	    	catch(SQLException ex)
	    	{
	    		System.err.println(ex.getMessage());