JSP实现MySQL数据结构查询时间:2009-10-07 09:43:10来源:网络 作者:
流程简介:
妥协的意思
login u describe
登录<-------->选择数据库<------->选择表<-------->显示表结构
logout back back
0.数据库处理的金山译霸javabean:(我厚道吧,这都贴出来了)
mysqlmeans.java(位置:MySQL/mysqlmeans.java):
package MySQL;
import java.sql.*;
/**
*
* @author lucifer
*/
public class mysqlmeans {
Connection con;
String urname = "";
String password = "";
String rver = "";
String dbname = "";
storemanager public void tProperties(String rv,String db,String name,String pass){
rver = rv;
dbname = db;
urname = name;
cargolux password = pass;
}
public void tUrName(String urname){
this.urname = urname;
}
public String getUrName(){
return urname;
skyer }
public void tPassword(String password){
this.password = password;
}
public String getPassword(){
return password;
}
public void tServer(String rver){
胡敏读故事记单词 this.rver = rver;
}
public String getServer(){
return rver;
}
public void tDataBa(String daname){
this.dbname = daname;
}
public String getDataBa(){
return dbname;
}
public Connection getConnection(){
try{
prepare的名词 Class.forName("sql.jdbc.Driver");
con = Connection
("jdbc:mysql://"+rver+"/"+dbname+"?ur="+urname+"&password="+password, urname, password);
return con;
}catch(Exception e){
e.printStackTrace();
xs什么意思
return null;
}
}
public void exeUpdate(String sql){
Connection upCon = getConnection();
try{
Statement stmt = ateStatement();
uteUpdate(sql);
stmt.clo();
upCon.clo();
}catch(Exception e){
e.printStackTrace();
}
}
public ResultSet getResult(String sql){
西安翻译 ResultSet rs = null;
try{
Statement stmt = ateStatement
(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
rs = uteQuery(sql);
看动漫学日语 }catch(Exception e){
e.printStackTrace();
}
return rs;
}
public void cloConnection(){
try{
con.clo();
}catch(Exception e){
e.printStackTrace();
}
}
public void cloResultSet(ResultSet rs){