MySQL连接样例!
来源:互联网 发布:电子商务php 编辑:程序博客网 时间:2024/04/28 01:49
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;
public class OperateDB ...{
public static ResultSet queryDB(String sql)throws ClassNotFoundException...{
Connection con=null;
Statement stmt=null;
ResultSet rs=null;
//StringBuffer sb=new StringBuffer();
try...{
//Class.forName("com.mysql.jdbc.Driver");
con=OperateDB.getConnection(con);
//con=DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/menagerie","root","333");
stmt=con.createStatement();
rs=stmt.executeQuery(sql);
}catch(Exception e)...{
e.printStackTrace();
}
return rs;
}
public static int updateDB(String sql)throws ClassNotFoundException...{
Statement sm=null;
Connection con=null;
int affectRows=0;
try...{
con=OperateDB.getConnection(con);
//con=DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/menagerie","root","333");
sm=con.createStatement();
affectRows=sm.executeUpdate(sql);
}catch(Exception e)...{
e.printStackTrace();
System.out.println("error updateDB!");
affectRows=Statement.EXECUTE_FAILED;
}finally...{
closeStatement(sm);
}
return affectRows;
}
public static void closeStatement(Statement sm)...{
if(sm!=null)...{
try...{
sm.close();
}catch(SQLException e)...{
e.printStackTrace();
}
}
}
/**//*public static void showResultSet(ResultSet rs){
if(rs==null){
return;
}
try{
ResultSetMetaData md=rs.getMetaData();
int columnCount = md.getColumnCount();
if(!rs.isBeforeFirst()){
rs.beforeFirst();
}
while(rs.next()){
for(int i=0;i<columnCount;i++){
System.out.print(rs.getObject(i)+" ");
}
System.out.print(rs.getObject(columnCount)+" ");
rs.beforeFirst();
}
}catch(SQLException e){
e.printStackTrace();
}
}*/
public static Connection getConnection(Connection con) throws ClassNotFoundException...{
try...{
Class.forName("com.mysql.jdbc.Driver");
if(con==null)...{
con=DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/menagerie","root","333");
}
}catch(SQLException e)...{
e.printStackTrace();
}
return con;
}
public static void closeConnection(Connection con)...{
if(con!=null)...{
try...{
con.close();
}catch(SQLException e)...{
e.printStackTrace();
}
}
}
public static void main(String []args) throws ClassNotFoundException...{
String sql="";
ResultSet rs=null;
Connection con=null;
Statement sm=null;
int inte=0;
sql="select * from pet;";
String updatesql="update pet set sex=null where birth='1997-12-09'";
try...{
rs=OperateDB.queryDB(sql);
//OperateDB.showResultSet(rs);
while(rs.next())...{
System.out.println(rs.getObject("name"));
}
inte=OperateDB.updateDB(updatesql);
System.out.println("updateDB= "+inte);
}catch(Exception e)...{
e.printStackTrace();
}
finally...{
try...{
rs.close();
}catch(SQLException e)...{
e.printStackTrace();
}
closeStatement(sm);
closeConnection(con);
}
}
}
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;
public class OperateDB ...{
public static ResultSet queryDB(String sql)throws ClassNotFoundException...{
Connection con=null;
Statement stmt=null;
ResultSet rs=null;
//StringBuffer sb=new StringBuffer();
try...{
//Class.forName("com.mysql.jdbc.Driver");
con=OperateDB.getConnection(con);
//con=DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/menagerie","root","333");
stmt=con.createStatement();
rs=stmt.executeQuery(sql);
}catch(Exception e)...{
e.printStackTrace();
}
return rs;
}
public static int updateDB(String sql)throws ClassNotFoundException...{
Statement sm=null;
Connection con=null;
int affectRows=0;
try...{
con=OperateDB.getConnection(con);
//con=DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/menagerie","root","333");
sm=con.createStatement();
affectRows=sm.executeUpdate(sql);
}catch(Exception e)...{
e.printStackTrace();
System.out.println("error updateDB!");
affectRows=Statement.EXECUTE_FAILED;
}finally...{
closeStatement(sm);
}
return affectRows;
}
public static void closeStatement(Statement sm)...{
if(sm!=null)...{
try...{
sm.close();
}catch(SQLException e)...{
e.printStackTrace();
}
}
}
/**//*public static void showResultSet(ResultSet rs){
if(rs==null){
return;
}
try{
ResultSetMetaData md=rs.getMetaData();
int columnCount = md.getColumnCount();
if(!rs.isBeforeFirst()){
rs.beforeFirst();
}
while(rs.next()){
for(int i=0;i<columnCount;i++){
System.out.print(rs.getObject(i)+" ");
}
System.out.print(rs.getObject(columnCount)+" ");
rs.beforeFirst();
}
}catch(SQLException e){
e.printStackTrace();
}
}*/
public static Connection getConnection(Connection con) throws ClassNotFoundException...{
try...{
Class.forName("com.mysql.jdbc.Driver");
if(con==null)...{
con=DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/menagerie","root","333");
}
}catch(SQLException e)...{
e.printStackTrace();
}
return con;
}
public static void closeConnection(Connection con)...{
if(con!=null)...{
try...{
con.close();
}catch(SQLException e)...{
e.printStackTrace();
}
}
}
public static void main(String []args) throws ClassNotFoundException...{
String sql="";
ResultSet rs=null;
Connection con=null;
Statement sm=null;
int inte=0;
sql="select * from pet;";
String updatesql="update pet set sex=null where birth='1997-12-09'";
try...{
rs=OperateDB.queryDB(sql);
//OperateDB.showResultSet(rs);
while(rs.next())...{
System.out.println(rs.getObject("name"));
}
inte=OperateDB.updateDB(updatesql);
System.out.println("updateDB= "+inte);
}catch(Exception e)...{
e.printStackTrace();
}
finally...{
try...{
rs.close();
}catch(SQLException e)...{
e.printStackTrace();
}
closeStatement(sm);
closeConnection(con);
}
}
}
- MySQL连接样例!
- Java连接MySQL例
- Matlab连接MySQL小例
- C#连接MySql小例
- MYSQl 连接
- 连接MySQL
- mysql连接
- MySQL连接
- 连接MySQl
- 连接mysql
- MySQL连接
- 连接MySQL
- MySql连接
- mysql连接
- mysql连接
- MySQL连接
- mysql 连接
- mysql连接
- 进程间发送数据的问题
- SQL SERVER 与ACCESS、EXCEL的数据转换
- 电脑新装上myeclipse6,出现问题,打不开?
- python的web framework
- *p++与(*p)++与*(p++)
- MySQL连接样例!
- NSGA2代码分析——dominance.c
- 项目经理如何管理?
- Asp.net 中删除上传的图片
- oracle-merge用法详解
- cs,ds,ss,es?即cs,ds,ss,es的区别
- Ubuntu8.04 下安装 QT for X11 4.4.0
- 在server2003上运行asp.net时出错
- 改变标签的文字颜色