JDBC 关于通用查询

来源：互联网发布：华为quik是什么软件编辑：程序博客网时间：2024/05/16 18:47

关于通用查询

package test20140213;import java.sql.Connection;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;/** *  * @author shihuafu * */public class Query {//selectpublic static void query(String TableName,Connection ConnName) throws SQLException {Connection conn = null;PreparedStatement pstmt1 = null;PreparedStatement pstmt2 = null;ResultSet rs1 = null;ResultSet rs2 = null;String sql1 = "select count(1) from all_tab_columns where table_name= upper('"+TableName+"')";//String sql3 = "select column_name from all_tab_columns where table_name= upper('"+TableName+"')";String sql2 = "select * from "+TableName+"";try {conn = ConnName;//数据库连接对象//用于执行sql语句的对象pstmt1 = conn.prepareStatement(sql1);pstmt2 = conn.prepareStatement(sql2);rs1 = pstmt1.executeQuery();///结果集rs2 = pstmt2.executeQuery();///结果集while(rs1.next()){int count = rs1.getInt(1);while(rs2.next()){System.out.print("{");for(int i = 1;i <= count; i++){System.out.print("'"+rs2.getString(i)+"'");}System.out.print("}");System.out.println();}}} catch (SQLException e) {e.printStackTrace();}finally{rs1.close();pstmt1.close();rs2.close();pstmt2.close();conn.close();}}public static void main(String[] args) throws SQLException {query("tbl_lztest",DBConnDev.getConn());}}

关于Oracle连接

package test20140213;import java.sql.Connection;import java.sql.DriverManager;import java.sql.SQLException;/** *  * @author shihuafu * */public class DBConnInt {//public static String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";public static String driverName = "oracle.jdbc.driver.OracleDriver";//public static String url = "jdbc:sqlserver://127.0.0.1:1434;DatabaseName=member";    //public static String url = "jdbc:oracle:thin:@10.10.164.83:1521:pdserver";public static String url = "jdbc:oracle:thin:@127.0.0.1:1521:orcl";public static String username="scott";public static String password="shihua";public static Connection getConn(){Connection conn = null;if (conn==null) {try {Class.forName(driverName);conn = DriverManager.getConnection(url,username,password);} catch (ClassNotFoundException e) {System.out.println("jar包可能未导入");}catch (SQLException e) {System.out.println("请检查数据库url和用户名密码");}}return conn;}public static void main(String[] args) {System.out.println(getConn());}}

0 0