dbserver.java

JAVA关于数据库DB连接的小例子程序

package struts.action;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import javax.sql.DataSource;

public class DBserver {
	DataSource dataSource;
	public DBserver(DataSource dataSource){
		this.dataSource = dataSource;
	}
	public  void conn() throws SQLException{
		
		Connection connect = null;
		connect = dataSource.getConnection();
		Statement stmt = connect.createStatement();
		
		String sql = "select * from mybook where id = "+3+"";
		ResultSet rs = stmt.executeQuery(sql);
		while(rs.next()){
			String r = rs.getString(3);
			System.out.println(r);
		}
	}
	
	
}