?? connect.java
字號(hào):
package bean;
import java.sql.*;
public class connect {
private Statement stmt;
private Connection conn;
public static void main(String[] args){
connect con = new connect();
String sql = "insert into regist values('monk','F',21,'shandong','4-4-08','6-4-08','13439910228',21)";
con.executeUpdate(sql);
ResultSet rs = con.executeQuery("select * from regist");
try {
while(rs.next()){
System.out.println(rs.getString("姓名"));
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public connect(){
try
{
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
String url="jdbc:oracle:thin:@localhost:1521:oracle";
String user="jerry";
String password="123456";
conn = DriverManager.getConnection(url,user,password);
stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
}catch(Exception e){
e.printStackTrace();
System.out.println("failed!");
}
}
public ResultSet executeQuery(String sql){
try {
return stmt.executeQuery(sql);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return null;
}
public int executeUpdate(String sql){
try {
return stmt.executeUpdate(sql);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return 0;
}
public void close(){
try {
this.conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
/*Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
String url="jdbc:oracle:thin:@localhost:1521:orcl";
//orcl為你的數(shù)據(jù)庫的SID
String user="scott";
String password="tiger";
Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from test";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()) {%>
您的第一個(gè)字段內(nèi)容為：<%=rs.getString(1)%>
您的第二個(gè)字段內(nèi)容為：<%=rs.getString(2)%>
<%}%>
<%out.print("數(shù)據(jù)庫操作成功，恭喜你");%>
<%rs.close();
stmt.close();
conn.close(); */
//package bean;
//
//import java.sql.*;
//
//public class connect {
//
// private String username = "jerry";
// private String password = "123456";
// private String database = "taskdata";
// private Connection conn = null;
// private ResultSet rs = null;
//
// public connect()
// {
// /*try{
// Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
// }
// catch(Exception ex)
// {
// System.err.println(ex.getMessage());
// }*/
// }
//
// public ResultSet executeQuery(String sql)
// {
// rs = null;
// try{
// DriverManager.registerDriver(new oracle.jdbc.OracleDriver());
// conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1527:oracle",username,password);
// Statement stmt = conn.createStatement();
// rs = stmt.executeQuery(sql);
// }
// catch(SQLException ex)
// {
// System.err.println("connect.executeQuery(): " + ex.getMessage());
// }
//
// return rs;
// }
//
// public void executeInsert(String sql)
// {
// try{
// DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
// conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1527:oracle"+ database,username,password);
// Statement stmt = conn.createStatement();
// stmt.executeUpdate(sql);
// }
// catch(SQLException ex)
// {
// System.err.println("connect.executeInsert(): " + ex.getMessage());
// }
// }
//
// public void executeDelete(String sql)
// {
// try{
// DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
// conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1527:oracle"+ database,username,password);
// Statement stmt = conn.createStatement();
// stmt.executeUpdate(sql);
// }
// catch(SQLException ex)
// {
// System.err.println("connect.executeDelete(): " + ex.getMessage());
// }
// }
//
//}
//import java.sql.*;
//
//public class connect {
// private Statement stmt;
// private Connection conn;
// private ResultSet rs = null;
// public connect(){ //實(shí)現(xiàn)數(shù)據(jù)庫連接
// try
// {
// Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
// String url="jdbc:oracle:thin:@localhost:1521:oracle";
// String user="jerry";
// String password="123456";
// conn= DriverManager.getConnection(url,user,password);
//
// }catch(Exception e){
// e.printStackTrace();
// System.out.println("failed!");
// }
// }
// public ResultSet executeQuery(String sql){ //執(zhí)行查詢
// try {
// this.stmt = this.conn.createStatement(
// ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
// this.rs = this.stmt.executeQuery(sql);
// } catch (SQLException e) {
// // TODO Auto-generated catch block
// e.printStackTrace();
// }
// return rs;
// }
// public int executeUpdate(String sql){ //執(zhí)行數(shù)據(jù)庫更新
// try {
// return stmt.executeUpdate(sql);
// } catch (SQLException e) {
// // TODO Auto-generated catch block
// e.printStackTrace();
// }
// return 0;
// }
// public void close(){
// try {
// this.conn.close();
// } catch (SQLException e) {
// // TODO Auto-generated catch block
// e.printStackTrace();
// }
// }
// public static void main(String[] args){
// connect con = new connect();
// String sql = "insert into regist values('monk','F',21,'shandong','04-4月-08','06-4月-08','13439910228',12)";
// //con.executeQuery(sql);
// con.executeUpdate(sql);
// ResultSet rs = con.executeQuery("select * from regist");
// try {
// while(rs.next()){
// System.out.println(rs.getString("姓名"));
// }
// } catch (SQLException e) {
// // TODO Auto-generated catch block
// e.printStackTrace();
// }
// try{
// String sql = "SELECT * From regist;";
// ResultSet rs1 = con.executeQuery(sql);
// while(rs1.next()){
// System.out.println("floor");
// System.out.println("room");
// System.out.println("contain");
// System.out.println("price");
// System.out.println("remark");
// }
// }
// catch (SQLException e){
// System.out.println(e.getMessage());
// }
// }
//
//}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -