func1.java

主要是描述的同学录系统

package com.user;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import com.user.Conn;
import com.user.Vo;

public class Func1 {
	Conn conn = null;
	Vo vo = null;
	Connection con = null;
	Statement stmt = null;// 一般的操作平台
	PreparedStatement pstmt = null;// 预处理操作平台
	ResultSet rs = null;
	boolean flag = false;
	public Vo getVo() {
		return vo;
	}
	public void setVo(Vo vo) {
		this.vo = vo;
	}
	public boolean dologin(String username, String password) {
		String str = "select * from xinxi where username='" + username
				+ "' and password='" + password + "'";
		try {
			conn = new Conn();
			con = conn.getConn();
			stmt = con.createStatement();
			rs = stmt.executeQuery(str);
			if (rs.next()) {
				vo = new Vo();
    			vo.setId(rs.getString(1));
    			vo.setUsername(rs.getString(2));
    			vo.setAddress(rs.getString(5));
    			this.setVo(vo);
    			flag=true;
			}
			rs.close();
			stmt.close();
			con.close();
		} catch (Exception e) {
			System.out.println("登陆出现异常");
			e.printStackTrace();
		}
		return flag;

	}
}