newsquerybean.java

已完成的jsp％2BjavaBean％2BServlet实例有增删改查很好的mvc源代码

package admin.manageBean;

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 NewsQueryBean {
	
	public ResultSet rs;
//	private int id;
	
	public NewsQueryBean() {
		init();
	}
	
	private void init(){
		try {
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		}
	}
	public Connection getConnection(){
		
		try {
			return DriverManager.getConnection("jdbc:odbc:news");
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return null;
	}
	
	public ResultSet newsQuery()
	{
		String sql="select * from news";
		Connection cn = getConnection();
		Statement ps;
		ResultSet rs=null;
		try {
			ps=cn.createStatement();
			rs=ps.executeQuery(sql);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return rs;
	}
	
	public ResultSet newsQueryId(int id)
	{
		String sql="select * from news where id = "+id+"";
		Connection cn = getConnection();
		Statement ps;
		ResultSet rs=null;
		try {
			ps=cn.createStatement();
			rs=ps.executeQuery(sql);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return rs;
	}

//	public int getId() {
//		return id;
//	}
//
//	public void setId(int id) {
//		this.id = id;
//	}
	

}