代码在里面 http://codepad.org/edr2CXeRJDBC数据库控制台
解决方案 »
- JAVA正则,Matcher类几个方法求指点
- java 连接 oracle rac的问题
- 怎么样将虚拟目录作为虚拟主机的默认目录???tomcat。。。感谢
- 线程同步问题
- Microsoft SQL Server 2000 Driver for JDBC——Service Pack 1支持JDK1.5吗?
- java中如何模拟鼠标点击事件?
- 我是一个初学者,里面有详细的源代码,请帮我看一下(运行错误)
- 如何知道操作系统是windows 还是redhat linux,以及如何调用linux的命令?
- 一个java初学者的问题:我是初学者
- 怎样捕捉ctrl+key和mouse右键事件?
- 一件怪事,0.25减0.20不等于0.0.5。求解释?
- 关于图片的问题
package first;
import java.sql.*;
import javax.sql.*;public class Jdbctest { /**
* @param args
*/
public static void main(String[] args) {
// TODO Auto-generated method stub
Connection conn = null;
ResultSet rs = null;
Statement stmt = null;
try {
//new oracle.jdbc.driver.OracleDriver();
Class.forName("oracle.jdbc.driver.OracleDriver");
String url = "jdbc:oracle:thin:@localhost:1521:orcl";
String dbUsername = "scott";
String dbPassword = "Oracle11g";
conn = DriverManager.getConnection(url,dbUsername,dbPassword);
stmt = conn.createStatement();
String sql = "select ename from employees "+"where deptno = 10";
rs = stmt.executeQuery(sql);
while(rs.next()){
String ename = rs.getString("ename");
//String loc = rs.getString("loc");
System.out.println(ename);
}
} catch (ClassNotFoundException e) {
// TODO: handle exception
e.printStackTrace();
} catch (SQLException e){
e.printStackTrace();
}finally{
try {
rs.close();
} catch (SQLException e2) {
e2.printStackTrace();
}
try {
stmt.close();
} catch (SQLException e2) {
e2.printStackTrace();
}
try {
conn.close();
} catch (SQLException e2) {
e2.printStackTrace();
}
}
}}
String sql = "select ename from employees "+"where deptno = 10";
rs = stmt.executeQuery(sql);
我把employees改成emp就对了
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;public final class JdbcUtils {
private static String url = "jdbc:mysql://localhost:3306/jdbc";
private static String user = "root";
private static String password = "755732"; private JdbcUtils() {
} static {
try {
Class.forName("com.mysql.jdbc.Driver");
} 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();
}
}
}
}
}