dataaccess.java

Ajax实现POST方式注册登录

package pack;
import java.sql.*;

public class DataAccess {
	//利用JDBC-ODBC或厂商驱动访问SQl Server 2000数据库
	public 	DataAccess() {
		try {
			//Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
		} catch(Exception e) {
			e.printStackTrace();
		}
	}
	//登录验证
	public boolean loginValidate(String name,String password) {
		ResultSet rs;
		try {
			//Connection myCon = DriverManager.getConnection("jdbc:odbc:News","sa","ok");
			Connection myCon = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=Ajax","sa","ok");
			Statement st = myCon.createStatement();
			String query_sql = "select * from Users where Name = '" + name + "' and Password = '" + password + "'";
			rs = st.executeQuery(query_sql);
			if(rs.next()) {
				return true;	
			} else {
				return false;
			}
		} catch(Exception e) {
			e.printStackTrace();
			return false;
		}	
	}
	
	//查询
	public ResultSet query(String sql) {
		try {
			Connection myCon = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=Ajax","sa","ok");
			Statement st = myCon.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
			return st.executeQuery(sql);
			
		} catch(Exception e) {
			e.printStackTrace();
			return null;
		}	
	}
	
	//删除
	public int update(String sql) {
		try {
			Connection myCon = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=Ajax","sa","ok");
			Statement st = myCon.createStatement();
			return st.executeUpdate(sql);
		} catch(Exception e) {
			e.printStackTrace();
			return 0;
		}	
	}
	public static void main(String[] args) {
		try {
			DataAccess a = new DataAccess();
	    	String sql = "select * from Users where Name='admin' and Password='admin'";
			ResultSet st = a.query(sql);
			while(st.next()) {
				System.out.println (st.getString(2));
			}
			System.out.println (a.update("insert into Users values('smy','smy','aa')"));
	    }
	    catch (Exception ex) {
	    }	
    }
}