package stuman;import java.io.*;
import java.sql.*; public class sqlBean{/// public Connection conn=null; public ResultSet rs=null; private String DatabaseDriver="com.mysql.jdbc.Driver";
String user="root";
String password="123456";
String url="jdbc:mysql://localhost/test?useUnicode=true&characterEncoding=GBK"
DatabaseConnStr="jdbc:mysql://localhost/test?useUnicode=true&characterEncoding=GBK", "root", "123456";
//定义方法
/*setXxx用于设置属性值;getXxx用于得到属性值*/
public void setDatabaseDriver(String Driver){
this.DatabaseDriver=Driver;
}
public String getDatabaseDriver(){
return (this.DatabaseDriver);
} public void setDatabaseConnStr(String ConnStr){
this.DatabaseConnStr=ConnStr;
}
public String getDatabaseConnStr(){
return (this.DatabaseConnStr);
} public sqlBean(){/////构造函数
try{
Class.forName(DatabaseDriver);
}
catch(java.lang.ClassNotFoundException e){
System.err.println("加载驱动器有错误:"+e.getMessage( ));
System.out.print("执行插入有错误:"+e.getMessage());//输出到客户端
}
}
public int executeInsert(String sql){
int num=0;
try{
conn = DriverManager.getConnection("jdbc:mysql://localhost/test?useUnicode=true&characterEncoding=GBK", "root", "123456");
Statement stmt=conn.createStatement( );
num=stmt.executeUpdate(sql);
}
catch(SQLException ex){
System.err.println("执行插入有错误:"+ex.getMessage() );
System.out.print("执行插入有错误:"+ex.getMessage());//输出到客户端
}CloseDataBase();
return num;
}
// display data
public ResultSet executeQuery(String sql){
rs=null;
try{
conn = DriverManager.getConnection("jdbc:mysql://localhost/test?useUnicode=true&characterEncoding=GBK", "root", "123456");
Statement stmt=conn.createStatement( );
rs=stmt.executeQuery(sql);
}
catch(SQLException ex){
System.err.println("执行查询有错误:"+ex.getMessage() );
System.out.print("执行查询有错误:"+ex.getMessage()); //输出到客户端
} return rs;
}
// delete data
public int executeDelete(String sql){
int num=0;
try{ conn = DriverManager.getConnection("jdbc:mysql://localhost/test?useUnicode=true&characterEncoding=GBK", "root", "123456");
Statement stmt=conn.createStatement( );
num=stmt.executeUpdate(sql);
}
catch(SQLException ex){
System.err.println("执行删除有错误:"+ex.getMessage() );
System.out.print("执行删除有错误:"+ex.getMessage()); //输出到客户端
}
CloseDataBase();
return num;
}
//////////////////
public void CloseDataBase(){
try{
conn.close();
}
catch(Exception end){
System.err.println("执行关闭Connection对象有错误:"+end.getMessage( ) );
System.out.print("执行执行关闭Connection对象有错误:有错误:"+end.getMessage()); //输出到客户端
}
}
}
我用的是mysql,数据库为test,原来数据库开发时有point.mdb和test.mdb两个文件
import java.sql.*; public class sqlBean{/// public Connection conn=null; public ResultSet rs=null; private String DatabaseDriver="com.mysql.jdbc.Driver";
String user="root";
String password="123456";
String url="jdbc:mysql://localhost/test?useUnicode=true&characterEncoding=GBK"
DatabaseConnStr="jdbc:mysql://localhost/test?useUnicode=true&characterEncoding=GBK", "root", "123456";
//定义方法
/*setXxx用于设置属性值;getXxx用于得到属性值*/
public void setDatabaseDriver(String Driver){
this.DatabaseDriver=Driver;
}
public String getDatabaseDriver(){
return (this.DatabaseDriver);
} public void setDatabaseConnStr(String ConnStr){
this.DatabaseConnStr=ConnStr;
}
public String getDatabaseConnStr(){
return (this.DatabaseConnStr);
} public sqlBean(){/////构造函数
try{
Class.forName(DatabaseDriver);
}
catch(java.lang.ClassNotFoundException e){
System.err.println("加载驱动器有错误:"+e.getMessage( ));
System.out.print("执行插入有错误:"+e.getMessage());//输出到客户端
}
}
public int executeInsert(String sql){
int num=0;
try{
conn = DriverManager.getConnection("jdbc:mysql://localhost/test?useUnicode=true&characterEncoding=GBK", "root", "123456");
Statement stmt=conn.createStatement( );
num=stmt.executeUpdate(sql);
}
catch(SQLException ex){
System.err.println("执行插入有错误:"+ex.getMessage() );
System.out.print("执行插入有错误:"+ex.getMessage());//输出到客户端
}CloseDataBase();
return num;
}
// display data
public ResultSet executeQuery(String sql){
rs=null;
try{
conn = DriverManager.getConnection("jdbc:mysql://localhost/test?useUnicode=true&characterEncoding=GBK", "root", "123456");
Statement stmt=conn.createStatement( );
rs=stmt.executeQuery(sql);
}
catch(SQLException ex){
System.err.println("执行查询有错误:"+ex.getMessage() );
System.out.print("执行查询有错误:"+ex.getMessage()); //输出到客户端
} return rs;
}
// delete data
public int executeDelete(String sql){
int num=0;
try{ conn = DriverManager.getConnection("jdbc:mysql://localhost/test?useUnicode=true&characterEncoding=GBK", "root", "123456");
Statement stmt=conn.createStatement( );
num=stmt.executeUpdate(sql);
}
catch(SQLException ex){
System.err.println("执行删除有错误:"+ex.getMessage() );
System.out.print("执行删除有错误:"+ex.getMessage()); //输出到客户端
}
CloseDataBase();
return num;
}
//////////////////
public void CloseDataBase(){
try{
conn.close();
}
catch(Exception end){
System.err.println("执行关闭Connection对象有错误:"+end.getMessage( ) );
System.out.print("执行执行关闭Connection对象有错误:有错误:"+end.getMessage()); //输出到客户端
}
}
}
我用的是mysql,数据库为test,原来数据库开发时有point.mdb和test.mdb两个文件
解决方案 »
- mysql怎么插入“SAINT BARTHÉLEMY”
- 请问一下 mysql数据库添加删除更新的存储过程怎么样生成的啊
- 两个200w的表联合查询,如果有字符串相等的条件,我是不是要先查出来再程序判断字符串是不是相等
- 不知道是不是自己太弱了~~对Mysql彻底失望拉~100w数据有索引,检索竟然要1分钟~
- 急~~~急```满分
- 求一条SQL
- 一个关于myodbc的问题?
- mysql5.6的trigger问题
- 怎样实现日期功能?
- 给mysql数据库的表格添加记录,int格式的字段显示正常,varchar格式的字段显示问号
- 还是同步问题,谁能提供一种多个服务器同步的模式?具体要求如下:
- 出错了,mysql 在两台计算机上实现数据同步。(主从模式)
String passwd = "tiger";
Connection conn = null;
String charset = null;
public TestCharset() {
}
public void connect() throws SQLException, ClassNotFoundException {
//Class.forName("com.mysql.jdbc.Driver");
Class.forName("oracle.jdbc.driver.OracleDriver");
//String url = "jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=UTF-8";
String url0 = "jdbc:oracle:thin:@iihero:1521:ORA92";
conn = DriverManager.getConnection(url0, username, passwd);
charset = "GBK"; //url.substring(url.lastIndexOf("=")+1);
}
这些提示给你,信息量够吗?
http://topic.csdn.net/u/20090501/15/7548d251-aec2-4975-a9bf-ca09a5551ba5.html
http://topic.csdn.net/u/20100428/09/BC9E0908-F250-42A6-8765-B50A82FE186A.html
http://topic.csdn.net/u/20100626/09/f35a4763-4b59-49c3-8061-d48fdbc29561.html8、如何给分和结贴?
http://community.csdn.net/Help/HelpCenter.htm#结帖