dboperator.java

java的网络编程

package com.ntc.listen;

import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Connection;
import java.sql.Statement;
import java.sql.ResultSet;

public class DbOperator {
	public boolean UserLogin(String username, String password) {
		Connection con = null;
		Statement sm = null;
		ResultSet rs = null; 
		boolean isLogin = false;
		try{
			Class.forName("com.mysql.jdbc.Driver");
			con = DriverManager.getConnection("jdbc:mysql://localhost:3306/iedb","root","888888");
			sm = con.createStatement();
			String sql = "SELECT USER_NAME FROM USER_INFO WHERE " 
					   + "USER_NAME = '"+username+"' AND USER_PASSWORD='"+password+"' ";
			rs = sm.executeQuery(sql);
			if (rs.next())
            {
                isLogin = true;
            }
		}catch(ClassNotFoundException e){
			e.printStackTrace();
		}catch(SQLException e){
			e.printStackTrace();
		}finally{
			if(sm != null){
				try{
					sm.close();
				}catch(SQLException e){}
				sm = null;
			}
			if(con != null){
				try{
					con.close();
				}catch(SQLException e){}
				con = null;
			}
		}
		return isLogin;
	}
}