classp.java

课设做的工程分析

package jav;

import java.sql.*;

public class classp {

	
	Connection con = null;
	Statement stmt=null;
	ResultSet rs=null;
	DepBean dep;

	public classp() {
		String connectionUrl = "jdbc:sqlserver://localhost;"
				+ "databaseName=xueji;user=sha;password=123;";
		try {
			Class.forName("com.microsoft.jdbc.sqlsever.SQLServerDriver");
			con = DriverManager.getConnection(connectionUrl);
			stmt=con.createStatement();
		} catch (Exception e) {
			System.err.print("1:"+e.getMessage());
		}
	}

	public ResultSet QuerySelct(String sql) {
		try {
			rs = stmt.executeQuery(sql);
		} catch (Exception e) {
			System.err.print("2:"+e.getMessage());
		}
		return rs;
	}
	
	public void AddDep(String depID,String depName)
	{
		try{
			byte b1[]=dep.getDepID().getBytes("ISO-8859-1"); 
			depID=new String(b1);
			byte b2[]=dep.getDepName().getBytes("ISO-8859-1");
			depName=new String(b2);
			PreparedStatement stm=con.prepareStatement("insert into academy values(?,?)");
			stm.setString(1,depID);   stm.setString(2,depName);
			try{
				stm.executeQuery();
			}catch(Exception e){}
			con.close();
		}catch(Exception e){}
	}
}