myjdbc.java

一个简单的选课系统的源代码,本人的数据库课程的作品.数据库用的是db2

package Professor;

import java.sql.*;
import java.util.*;
import java.awt.*;


public class MyJDBC {
	Connection conn;
	Statement stmt;
	int insertValue=-1;
	public MyJDBC() throws Exception
	{
		String DriverName="COM.ibm.db2.jdbc.app.DB2Driver";
		Class.forName(DriverName);
		String url="jdbc:db2:crs";
		conn=DriverManager.getConnection(url,"db2admin","winprize");
		stmt=conn.createStatement();
	}
	public ResultSet exceteQuery(String sql) throws  Exception
	{
		ResultSet rs=stmt.executeQuery(sql);
		return rs;
	}
	public int insert(String sql) throws Exception
	{
		insertValue=stmt.executeUpdate(sql);
		return insertValue;
	}
}