sql.java

来自「数据库 学生综合管理系统 实现了学生课程教师管理 及学生选课」· Java 代码 · 共 44 行

package test;
import java.sql.*; 
public class sql {
	public ResultSet execsql(String query){
	String dbURL="jdbc:odbc:student"; 
	
	Statement stmt = null;
	ResultSet rs = null;


	String userName = "sa"; 
	String userPwd = ""; 
	Connection con;

	try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); 

	con = DriverManager.getConnection(dbURL, userName, userPwd); 
	System.out.println("Connection Successful!"); 
	stmt = con.createStatement();
	rs=stmt.executeQuery(query);
	
	//con.close();stmt.close();
	
	} 
	catch(Exception e) { 
	e.printStackTrace(); 
	}
		
		
		
	return rs;
		
		
		
		
		
		
		
		
		
	}

}