userinfodao.java

基于jsp的固定资产管理系统,自己做的

package DAO;
import java.sql.*;
import VO.*;
public class UserInfoDAO {
	
	public int insertUser(UserInfo user)
	{
		ConnectTo conto=new ConnectTo();
		Connection conn=conto.connect();
		String sql="insert into userinfo values(?,?,?,?)";
		int k=-1;
		PreparedStatement pstm=null;
		if(conn!=null)
		{
			String ID=user.getID();
			String tel=user.getUser_tel();
			int state=user.getRoam_state();
			int level=user.getCall_level();
			try
			{
				pstm=conn.prepareStatement(sql);
				pstm.setString(1, ID);
				pstm.setString(2,tel);
				pstm.setInt(3, state);
				pstm.setInt(4, level);
				k=pstm.executeUpdate();
			}
			catch(Exception e)
			{
				try
				{
					e.printStackTrace();
					pstm.close();
					conn.close();
				}catch(Exception e1){e1.printStackTrace();}
			}
		}
		return k;
	}
}