dbcontent.java

多功能学生宿舍管理系统 分布式体系结构

package myweb.DBContent;
import java.sql.*;
public class DBContent {
	private Connection con;
	private Statement stmt;
	
public DBContent(){
	
	String CLASSFORNAME="com.microsoft.jdbc.sqlserver.SQLServerDriver";
	String url="jdbc:microsoft:sqlserver://localhost:8888;DatabaseName=myweb";
	String user="sa";
	String password="123";
	
	
	try{
		
	Class.forName(CLASSFORNAME);
	con= DriverManager.getConnection(url,user,password);
	stmt=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
	
	}
	catch(Exception ex){
	
		ex.printStackTrace();
	}
	
}	

public void insert(String sql)throws Exception
{
	

	try{
		
		
		stmt.executeUpdate(sql);
		/*
		String name="ddddd";
		String pwd="lina";
	    PreparedStatement pstmt=con.prepareStatement("insert into test values(?,?)");
		pstmt.setString(1,"li");
		pstmt.setString(2,"na");
		pstmt.execute();*/
	
	}
	catch(Exception ex)
	{
	System.err.println("78787887878");
		ex.printStackTrace();	
	}
}

public ResultSet select(String sql){
	try
	{
	
	ResultSet result=stmt.executeQuery(sql);
	return result;

	}catch(Exception ex){
		ex.printStackTrace();
		return null;
	}
	
	
}
public void delete(String sql)
{

	try{
		
		stmt.executeUpdate(sql);
		
	}catch(Exception ex){
		
		ex.printStackTrace();
	}

}

public void update(String sql)
{
	try{
		
		 stmt.executeUpdate(sql);
		
	}catch(Exception ex){
		
		ex.printStackTrace();
	}
}

public void close()
{
try
{
	
stmt.close();
con.close();

}catch(Exception ex){
	
	ex.printStackTrace();
}

}

}