reporter.java

新闻发布系统～～ 做的一个小系统 拿出来与大家分想下～

package news_bean;
import java.sql.*;

public class reporter {
	private long j_id;
	private String j_name;
	private String j_xinbie;
	private int j_nianling;
	private String j_yaoqiu;
	private boolean j_pizhun;
	private String j_password;
	
	static Conn conn=new Conn();
	private  String sql;
	private  ResultSet rs;
	
	public long getJ_id() {
		return j_id;
	}
	public void setJ_id(long j_id) {
		this.j_id = j_id;
	}
	public String getJ_name() {
		return j_name;
	}
	public void setJ_name(String j_name) {
		this.j_name = j_name;
	}
	public int getJ_nianling() {
		return j_nianling;
	}
	public void setJ_nianling(int j_nianling) {
		this.j_nianling = j_nianling;
	}
	public String getJ_xinbie() {
		return j_xinbie;
	}
	public void setJ_xinbie(String j_xinbie) {
		this.j_xinbie = j_xinbie;
	}
	public String getPassword() {
		return j_password;
	}
	public void setPassword(String password) {
		this.j_password = password;
	}
	public boolean isPizhun() {
		return j_pizhun;
	}
	public void setPizhun(boolean pizhun) {
		this.j_pizhun = pizhun;
	}
	public String getYaoqiu() {
		return j_yaoqiu;
	}
	public void setYaoqiu(String yaoqiu) {
		this.j_yaoqiu = yaoqiu;
	}
	public  boolean login()
	{
		sql="select j_id from jizhe where j_name='"+this.j_name+"' and j_password='"+this.j_password+"' and j_pizhun="+true;
		rs=conn.executeQuery(sql);
		try 
		{
			if(rs.next())
			{
				long id =Long.parseLong(rs.getString("j_id"));
				this.setJ_id(id);
				rs.close();
				conn.close();
				return true;
			}
		}catch (Exception e){
			conn.close();
			return false;
		}
		conn.close();
		return false;
	
	}
	public boolean newJizhe(){
		try {
			java.lang.Class.forName("org.gjt.mm.mysql.Driver");
			Connection connect = DriverManager.getConnection("jdbc:mysql://localhost/news","root","103045");
			PreparedStatement sql = connect.prepareStatement("insert into jizhe(j_name,j_xinbie,j_nianling,j_yaoqiu,j_pizhun,j_password)values(?,?,?,?,?,?)");
			sql.setString(1, this.j_name);
			sql.setString(2, this.j_xinbie);
			sql.setInt(3, this.j_nianling);
			sql.setString(4, this.j_yaoqiu);
			sql.setBoolean(5, false);
			sql.setString(6, this.j_password);
			System.out.println(this.j_name+" "+this.j_nianling);
			int i = sql.executeUpdate();
			if( i > 0 )
				return true;
			else
				return false;
		}catch(Exception e)
		{
			e.printStackTrace();
			return false;
		}
	}
	public static void main(String args[])
	{
	//	sql = "insert into jizhe('j_name','j_xinbie','j_nianling','j_yaoqiu','j_pizhun','j_password') " +
		//"values('"+name+"','"+this.j_xinbie+"',"+this.j_nianling+",'"+this.j_yaoqiu+"',"+false+",'"+this.j_password+"')"; 
	}
}