userinfodaoimpl.java

自己做的一个火车票售票网站是课程设计 用的是servlet+jsp 数据库是ms

package com.daoImpl;

import com.dao.*;
import java.util.*;
import com.jdbc.*;
import java.sql.*;
import com.vo.*;

public class UserinfoDAOImpl implements UserinfoDAO {
	DataBaseConnection dbc = null;
	PreparedStatement psmt = null;
	String sql = null;
	ResultSet rs = null;

	public boolean isLogin(UserinfoVO vo) {
		boolean flag = false;
		try {
			sql = "select * from userinfo where userName=? and userPassword=?";

			dbc = new DataBaseConnection();

			psmt = dbc.getConnection().prepareStatement(sql);
			psmt.setString(1, vo.getUserName());
			psmt.setString(2, vo.getUserPassword());
			rs = psmt.executeQuery();
			if (rs.next()) {
				flag = true;
			}
			rs.close();
			psmt.close();
		} catch (Exception e) {

		} finally {
			dbc.close();
		}
		return flag;

	}

	public int insertUser(UserinfoVO vo){
		int result=0;
		try{
			sql="insert into userinfo(userName,userPassword,userEmail,userTrueName) values(?,?,?,?)";
			dbc = new DataBaseConnection();
			psmt = dbc.getConnection().prepareStatement(sql);
			psmt.setString(1,vo.getUserName());
			psmt.setString(2,vo.getUserPassword());
			psmt.setString(3, vo.getUserEmail());
			psmt.setString(4,vo.getUserTrueName());
			result=psmt.executeUpdate();
		}
		
		
		catch (Exception e){
			e.printStackTrace();
		}
		finally {
		
			dbc.close();
		}
		
		return result;
		
	}

}