JSP中访问MYSQL数库,,谁有现成的JAVABEAN啊,,最精典一点的,,,谢,,,,
谁有现成的JSP中联接MYSQL数据库的,javabean啊,最好包含查和执行的,,简洁精干一点的,,,谢谢啊~~~~ 问题点数：10、回复次数：10Top
1 楼kk2003317（痛并快乐着）回复于 2004-12-04 21:33:43 得分 0
网上搜一搜,很多的.Top
2 楼accsk（爱梦）回复于 2004-12-04 23:26:54 得分 0
jsp书里都有的Top
3 楼strutsone（伸手云龙关羽关云长）回复于 2004-12-05 07:04:48 得分 0
// Class.forName("com.mysql.jdbc.Driver");
// con = DriverManager.getConnection("jdbc:mysql://localhost/musiccollection", "root", "");
//stmt = con.createStatement();
//rs = stmt.executeQuery("SELECT * FROM info WHERE username = '" + username +
"'"+ "AND password = '" + password + "'");Top
4 楼zcsnet（大佬曾）回复于 2004-12-05 10:28:22 得分 0
网上有的写的不好Top
5 楼classjava（原始野人）回复于 2004-12-05 10:36:33 得分 0
javabean一般都是连接,偶写过都是这样^_^,这样javabean比较简洁Top
6 楼mascotzhuang（基督山伯爵）回复于 2004-12-05 11:11:53 得分 0
http://mascotzhuang.go.nease.net/Top
7 楼listhome（不想睡)(专回百分贴）回复于 2004-12-05 12:16:24 得分 5
SQLserver的你改一下了！
package com.rmyy;
import java.sql.*;
import javax.sql.*;
import java.io.*;
import javax.naming.*;
public class MSsql{
private Connection conn=null;
private Statement stmt=null;
private PreparedStatement prepstmt=null;
/**
*
*
*
**/
public MSsql(){
try{
getDataSource();
stmt=conn.createStatement();
}catch(Exception e){
System.err.println("MSsql init error:"+e);
}
}
private void getDataSource() {
try {
Context ctx = new InitialContext();
if (ctx == null)
throw new Exception("Boom - No Context");
DataSource ds =
(DataSource) ctx.lookup("java:comp/env/jdbc/userDB");
if (ds != null)
conn = ds.getConnection();
} catch (Exception e) {
System.err.println("getDataSource() error: " + e);
}
}
/**
*
*
*
**/
public MSsql(String sql){
try{
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=rmyy";
String user="sa";
String password="sa";
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
conn=DriverManager.getConnection(url,user,password);
prepareStatement(sql);
}catch(Exception e){
System.err.println("MSsql init error:"+e);
}
}
public Connection getConnection(){
return conn;
}
public void prepareStatement(String sql) throws SQLException{
prepstmt=conn.prepareStatement(sql);
}
public void setString(int index, String value) throws SQLException {
prepstmt.setString(index, value);
}
public void setInt(int index, int value) throws SQLException {
prepstmt.setInt(index, value);
}
public void setBoolean(int index, boolean value) throws SQLException {
prepstmt.setBoolean(index, value);
}
public void setDate(int index, Date value) throws SQLException {
prepstmt.setDate(index, value);
}
public void setLong(int index, long value) throws SQLException {
prepstmt.setLong(index, value);
}
public void setFloat(int index, float value) throws SQLException {
prepstmt.setFloat(index, value);
}
public void setBinaryStream(int index, InputStream in, int length) throws SQLException {
prepstmt.setBinaryStream(index, in, length);
}
public void clearParameters() throws SQLException {
prepstmt.clearParameters();
}
public PreparedStatement getPreparedStatement() {
return prepstmt;
}
public Statement getStatement() {
return stmt;
}
public ResultSet executeQuery(String sql) throws SQLException {
if (stmt != null){
return stmt.executeQuery(sql);
} else
return null;
}
/**
*
*
*
**/
public ResultSet executeQuery() throws SQLException {
if (prepstmt != null) {
return prepstmt.executeQuery();
} else
return null;
}
/**
*
*
*
**/
public void executeUpdate(String sql) throws SQLException {
if (stmt != null)
stmt.executeUpdate(sql);
}
/**
*
*
*
**/
public void executeUpdate() throws SQLException {
if (prepstmt != null)
prepstmt.executeUpdate();
}
/**
*
*
*
**/
public void close() {
try {
if (stmt != null) {
stmt.close();
stmt = null;
}
if (prepstmt != null) {
prepstmt.close();
prepstmt = null;
}
conn.close();
conn = null;
} catch (Exception e) {
System.err.println("MSsql close error: " + e);
}
}
}Top
8 楼iaijava（deyizi）回复于 2004-12-05 13:10:13 得分 0
上面的大哥用的是mvc的思想在做吧 ????Top
9 楼zcsnet（大佬曾）回复于 2004-12-05 17:10:21 得分 0
晕倒,,太长~~~~Top
10 楼jackwin（想过更好的生活!!）回复于 2004-12-05 22:10:36 得分 5
我最近做的小bean
第一个文件(JobDB.java是用于存放主函数)
package gdbye.com.date.jobdb;
import java.sql.*;
import javax.naming.*;
import javax.sql.*;
import java.util.*;
import gdbye.com.date.jobdetails.*;//加载我定义的三个类到主类
import gdbye.com.date.jobsqlstr.*;
import gdbye.com.date.alldone.*;
public class JobDB{
private AllDone AllDone;
private JobSqlStr JobSqlStr;
private String dbUrl = "jdbc:mysql://localhost:3306/数据库名";
private String dbUser = "帐号";
private String dbPwd = "密码";
public JobDB() throws Exception{
Class.forName("com.mysql.jdbc.Driver");//加载mysql驱动
}
public JobDetails getJobCases(String caseid) throws Exception{
Connection con = null;//建立一个数据库连接变量
PreparedStatement prepStmt = null;//以prepoare方式访问数据库
ResultSet rs = null;//建立一个空集
try{
con = (Connection)AllDone.getConnection(dbUrl,dbUser,dbPwd);//连接数据库调alldone中的类getConnection
String selectStatement = JobSqlStr.job_case_select();//返回我要的sql语句
prepStmt = con.prepareStatement(selectStatement);
prepStmt.setString(1,caseid);//sql参数传递
rs = prepStmt.executeQuery();//运行这个sql
if(rs.next()){//如果不空则将查到的记录存到jobDetails的类中
JobDetails db = new JobDetails(rs.getString(1),rs.getString(2),rs.getString(3),rs.getString(4),
rs.getString(5),rs.getString(6),rs.getString(7),rs.getString(8),
rs.getString(9),rs.getString(10));
prepStmt.close();//数据取完后关闲prepstmt
return db;
}
else{
return null;
}
}finally{
AllDone.closeResultSet(rs);//关闲集合
AllDone.closePrepStmt(prepStmt);//关闲stmt
AllDone.closeConnection(con);//断开数据库连接
}
}
}
第二个文件(AllDone.java数据库的连接与关闲)
package gdbye.com.date.alldone;
import java.sql.*;
import javax.sql.*;
import java.util.*;
public class AllDone{
public Connection getConnection(String dbUrl,String dbUser,String dbPwd) throws Exception{
return java.sql.DriverManager.getConnection(dbUrl,dbUser,dbPwd);
}
public void closeConnection(Connection con){
try{
if(con!=null)con.close();
}catch(Exception e){
e.printStackTrace();
}
}
public void closePrepStmt(PreparedStatement prepStmt){
try{
if(prepStmt!=null)prepStmt.close();
}catch(Exception e){
e.printStackTrace();
}
}
public void closeResultSet(ResultSet rs){
try{
if(rs!=null)rs.close();
}catch(Exception e){
e.printStackTrace();
}
}
}
第三个文件(JobSqlStr.java存放所有sql语句)
package gdbye.com.date.jobsqlstr;
public class JobSqlStr{
public String job_case_select() throws Exception{
String job_case_selectRs = "select * from news where id = ?";
return job_case_selectRs;
}
}
第三个文件(JobDetails.java用于存放数据的类)Top
