dboperator.java

很好的东东 本人随便做的 仅供学习之用

package jhyy.login;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class DBoperator {
	private Connection connection;
	private PreparedStatement statement;
	
	public DBoperator(){
		try {
			Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		}
	}
	public void getConnection() {
		try {
			connection=DriverManager.getConnection("jdbc:microsoft:sqlserver://10.10.8.184:1433;databaseName=JHYY", "jhyy", "jhyy");
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
	public boolean login(String table,String name,String password)
	{
		try {
			
			getStatement(table,name,password);
			
		if(statement.executeQuery().next())
			{
				return true;
			}				
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return false;
	}
	public String login2(String table,String name,String password)
	{
		try {
			
			getStatement(table,name,password);
			ResultSet rs=statement.executeQuery();
		if(rs.next())
			{
				return rs.getString("positions");
				
			}				
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return null;
	}
	public void getStatement(String table,String name,String password) {
		try {
			getConnection();
			statement=connection.prepareStatement("select * from "+table+" where name=? and password=?");	
			statement.setString(1, name);
			statement.setString(2, password);
		} catch (SQLException e) {
			e.printStackTrace();
		}
		}
	
}