conntest.java

一个简单的C/S模式考试系统

import java.sql.*;
public class ConnTest {
    Connection conn;
    Statement sm;
    String exec;
    boolean t=false;
    
    public ConnTest() {
        
    }
    public String connresult(String db,String name,String user,String pass){
    	if(db.equals("sqlserver")){
    	try{
    		Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
    	}
    	catch(ClassNotFoundException err){
    		exec="驱动未找到";
    	}
    	try{
    		conn=DriverManager.getConnection("jdbc:sqlserver://127.0.0.1:1433;DatabaseName="+name,user,pass);
    		sm=conn.createStatement();
    		t=sm.execute("select * from user1");
    			conn.close();
    		
    	}
    	catch(SQLException error){
    		exec="数据库未找到";
    	}
    	
    	if(t)
    	exec="true";
    	}
    		if(db.equals("access")){
    	try{
    		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    	}
    	catch(ClassNotFoundException err){
    		exec="数据源未找到";
    	}
    	try{
    		conn=DriverManager.getConnection("jdbc:odbc:"+name,user,pass);
    		sm=conn.createStatement();
    		t=sm.execute("select * from user1");
    			conn.close();
    		
    	}
    	catch(SQLException error){
    		exec="数据库未找到";
    	}
    	
    	if(t)
    	exec="true";
    	}
    		if(db.equals("mysql")){
    	try{
    		Class.forName("com.mysql.jdbc.Driver");
    	}
    	catch(ClassNotFoundException err){
    		exec="驱动未找到";
    	}
    	try{
    		
    		conn=DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/"+name+"?user="+user+"&password="+pass);
    		sm=conn.createStatement();
    		t=sm.execute("select * from user1");
    			conn.close();
    		
    	}
    	catch(SQLException error){
    		exec="数据库登陆错误";
    	}
    	
    	if(t)
    	exec="true";
    	
    	}
    	if(db.equals("access数据库直连")){
    	try{
    		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    	}
    	catch(ClassNotFoundException err){
    		exec="数据驱动未找到";
    	}
    	try{
    		conn=DriverManager.getConnection("jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ="+name,user,pass);
    		sm=conn.createStatement();
    		t=sm.execute("select * from user1");
    			conn.close();
    		
    	}
    	catch(SQLException error){
    		exec="数据库未找到";
    	}
    	
    	if(t)
    	exec="true";
    	}
    	return exec;
    }
   // public static void main(String args[]){
    //	ConnTest c=new ConnTest();
    //	System.out.print(c.connresult("mysql","test","root","123456"));
    	
   // }
}