package com.zgm.jdbc;import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;public final class JdbcUtils {
private final static String url = "jdbc:oracle:thin:@localhost:1521:XE";
private final static String user = "scott";
private final static String password = "tiger"; private void jdbcUtils() {
} static {
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
} catch (ClassNotFoundException e) {
throw new ExceptionInInitializerError(e);
}
} public static Connection getConnection() throws SQLException {
return DriverManager.getConnection(url, user, password);
} public static void free(ResultSet rs, Statement st, Connection conn) {
try {
if (rs != null)
rs.close();
} catch (SQLException e) {
e.printStackTrace();
} finally {
try {
if (st != null)
st.close();
} catch (SQLException e) {
e.printStackTrace();
} finally {
if (conn != null)
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
}
package com.zgm.jdbc;import java.io.BufferedWriter;
import java.io.File;
import java.io.FileWriter;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;public class DB {
public static void main(String[] args) throws Exception {
read();
} static void read() throws SQLException {
Connection conn=null;
Statement st=null;
ResultSet rs=null;
try{
conn=JdbcUtils.getConnection();
st=conn.createStatement();
rs=st.executeQuery("select * from ROOT");
while(rs.next()){
System.out.println(rs.getObject(1)+"\t"+rs.getObject(2)+"\t"+rs.getObject(3));
}
}finally{
JdbcUtils.free(rs, st, conn);
}
}
}
Exception in thread "main" java.lang.NoClassDefFoundError: Could not initialize class com.zgm.jdbc.JdbcUtils
at com.zgm.jdbc.DB.read(DB.java:29)
at com.zgm.jdbc.DB.main(DB.java:13)
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;public final class JdbcUtils {
private final static String url = "jdbc:oracle:thin:@localhost:1521:XE";
private final static String user = "scott";
private final static String password = "tiger"; private void jdbcUtils() {
} static {
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
} catch (ClassNotFoundException e) {
throw new ExceptionInInitializerError(e);
}
} public static Connection getConnection() throws SQLException {
return DriverManager.getConnection(url, user, password);
} public static void free(ResultSet rs, Statement st, Connection conn) {
try {
if (rs != null)
rs.close();
} catch (SQLException e) {
e.printStackTrace();
} finally {
try {
if (st != null)
st.close();
} catch (SQLException e) {
e.printStackTrace();
} finally {
if (conn != null)
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
}
package com.zgm.jdbc;import java.io.BufferedWriter;
import java.io.File;
import java.io.FileWriter;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;public class DB {
public static void main(String[] args) throws Exception {
read();
} static void read() throws SQLException {
Connection conn=null;
Statement st=null;
ResultSet rs=null;
try{
conn=JdbcUtils.getConnection();
st=conn.createStatement();
rs=st.executeQuery("select * from ROOT");
while(rs.next()){
System.out.println(rs.getObject(1)+"\t"+rs.getObject(2)+"\t"+rs.getObject(3));
}
}finally{
JdbcUtils.free(rs, st, conn);
}
}
}
Exception in thread "main" java.lang.NoClassDefFoundError: Could not initialize class com.zgm.jdbc.JdbcUtils
at com.zgm.jdbc.DB.read(DB.java:29)
at com.zgm.jdbc.DB.main(DB.java:13)
解决方案 »
- SSH框架用log4j怎么把数据存入SQL数据库
- 不显示删除回复显示所有回复显示星级回复显示得分回复 jsp上面的file标签用了以后无法传到后台怎么办
- 求救 大侠速度来看。
- hibernate search + 庖丁 不能生成索引文件!!!
- struts2里有关<s:autocompleter>标签的两个小问题,望高手指教
- 为什么Hibernate没有返回java.util.Date类型,却返回了java.sql.Date类型
- SQLServer 编码问题
- 如何把AXISCLASSPATH添加到classpath中去
- 用Hibernate3.3.2 this.hibernateTemplate.find查询list返回的都是空元素,求大神
- 哪里有J2EE编程指南1.3版的英文电子版下载?
- 24个月 第一个月是当前系统时间,后面递增23个怎么搞
- struts2 acton找不到
private void jdbcUtils() {
}
这是什么?构造函数他弟弟,瞎写函数?