dengludao.java

简单的BBS系统

package com.zjy.struts.mypackage;

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

import com.zjy.struts.form.DengluForm;

public class DengluDao {
	public PreparedStatement ps = null;

	public Connection con = null;

	public DengluDao() {
		try {
			Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver")
					.newInstance();
			String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=luntan";
			String user = "sa";
			String password = "";
			con = DriverManager.getConnection(url, user, password);
		} catch (Exception e) {
			// TODO: handle exception
		}
	}
	public int denglu(DengluForm dengluForm) {
		Statement stmt = null;
		ResultSet rs = null;
		int rst = 0;

		try {

			stmt = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
					ResultSet.CONCUR_READ_ONLY);
			String sql = "select * from users where name='"
					+ bx(dengluForm.getUsername()) + "'";
			rs = stmt.executeQuery(sql);
			if (rs.next()) {
				if (rs.getString("password").equals(dengluForm.getPassword())) {
					if(rs.getInt(9)==1){
						rst=2;
					}else{
						rst = 1;
					}
				} else {
					rst = 0;
				}

				// System.out.print(rst);
			} else {
				rst = 0;
			}

		} catch (Exception e) {
			// TODO: handle exception
			System.out.print(e);
		}finally{
			try {
				rs.close();
				stmt.close();
				con.close();
			} catch (Exception e) {
				// TODO: handle exception
			}
		}

		return rst;
	}
	public String bx(String s) {
		try {
			byte b[] = s.getBytes("iso-8859-1");
			s = new String(b);
		} catch (Exception e) {
		}
		return s;
	}
}