db.java

我实习时候的设计

package cn.yyl.lon;
import java.sql.*;

import cn.yxh.util.DBConn;
public class DB {
	

	PreparedStatement stmt = null;
	ResultSet rs=null;
	
	public void addRecord(String teacherid,String password,String teachername,String sex,String zhicheng,String department)
	{
		Connection conn = DBConn.getConn(); 
		try {
			stmt=conn.prepareStatement("insert into teacher(teacherid,password,teachername,sex,zhicheng,department) values(?,?,?,?,?,?)");
			stmt.setString(1, teachername);
			stmt.setString(2, teachername);
			stmt.setString(3, teachername);
			stmt.setString(4,sex);
			stmt.setString(5,zhicheng);
			stmt.setString(6, department);
			stmt.execute();
			
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	
	}
	
	public ResultSet teacherdemo(String  teacherid)
	{	Connection conn = DBConn.getConn();
		try {
			stmt=conn.prepareStatement("select * from teacher where teacherid=?");
			stmt.setString(1, teacherid);
			rs=stmt.executeQuery();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return rs;
	}
	public void update(String teacherid,String password,String teachername,String sex,String zhicheng,String department )
	{
		Connection conn = DBConn.getConn();
		try {
			stmt=conn.prepareStatement("update teacher set teachername=?,sex=?,zhicheng=?,department=? where teacherid=? and password=?");
			stmt.setString(1, teachername);
			stmt.setString(2, sex);
			stmt.setString(3, zhicheng);
			stmt.setString(4, department);
			stmt.setString(5, teacherid);
			stmt.setString(6, password);
			stmt.execute();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	public ResultSet search(String username)
	{	Connection conn = DBConn.getConn();
		try {
			stmt=conn.prepareStatement("select * from teacher where teachername like ?");
			stmt.setString(1,username);
			rs=stmt.executeQuery();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return rs;
		
	}
	
}