userdbopreation.java

JSP初学者

package xinwen;
import java.sql.*;
public class UserDbOpreation {
    Connection dbConnection = null;
	PreparedStatement pStatement = null;
	ResultSet res = null;

	public int UsersInsert(User name) throws SQLException
	{
		int result = 0;
		try
		{
			dbConnection = ConnectionManager.getConnection();

			String sqlStr = "insert into User (loginname,password) values(?,?)";
			pStatement = dbConnection.prepareStatement(sqlStr);
			pStatement.setString(1, name.getName());
			pStatement.setString(2, name.getPassWord());
			pStatement.executeUpdate();

			sqlStr = "select count(*) from User ";
			pStatement = dbConnection.prepareStatement(sqlStr);
			res = pStatement.executeQuery();
		}
		catch (Exception e)
		{
			e.printStackTrace();
		}
		finally
		{
			ConnectionManager.closeResultSet(res);
			ConnectionManager.closeStatement(pStatement);
			ConnectionManager.closeConnection(dbConnection);
		}
		return result;
	}


}