try {
Class.forName ("oracle.jdbc.driver.OracleDriver");
connection = DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:G", "G", "G");
} catch(ClassNotFoundException clsex) {
}
catch(SQLException sqlex) {
}
Class.forName ("oracle.jdbc.driver.OracleDriver");
connection = DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:G", "G", "G");
} catch(ClassNotFoundException clsex) {
}
catch(SQLException sqlex) {
}
解决方案 »
- 关于java socket流问题
- 谁能给我解释下程序中的this是干什么的?
- Java有没有类似Jquery.ui那样的控件包
- 求份GB2312汉字拼音表
- 使用dataInputStream和dataOutputStream造成“死锁”或“阻塞”
- 高分求一个数组的简单的算法
- 请教 Applet运行时报错:NullPointerException 不胜感激!!!!!
- 这个判断瑞年平年的JAVA程序哪里有问题?看不出来
- TreeMap一般是按键排序,我的这个程序希望按值排序该怎样操作?
- 请问 int compareTo(String other)怎么用啊
- assertion wrapper 是什么?帮忙解释一下。为什么在docs里面查不到?!
- 请教有关Runtime.exec
class connetionJDBC{//建立连接类 Connection con;
public Connection getConnection(){
try {
Class.forName ("oracle.jdbc.driver.OracleDriver");
con = DriverManager.getConnection("jdbc:oracle:thin:@url", "user", "password");
return con;
} catch(Exception clsex) {
return null;
}
}}
class userJDBC{//对数据库操作类
connetionJDBC test;
Connection conn = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
String sql="select....";
userJDBC(){
try {
con = test.getConnection();
pstmt = conn.prepareStatement("sql");
rs = pstmt.executeQuery();
while(rs.next()) {
listFormhashtable.put(rs.getString("id"),rs.getString("name"));
}
} catch(Exception clsex) { }
}
}
import java.sql.*;public class cn
{
String cline="com.microsoft.jdbc.sqlserver.SQLServerDriver";
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=xiruo";
String user="sa";
String pass="";
Connection conn=null;
ResultSet rs=null;public cn() {
try {
Class.forName(cline);
}
catch(java.lang.ClassNotFoundException e)
{
System.err.println("classnotfound:"+e.getMessage());
}
}public ResultSet executeQuery(String sql) {
rs=null;
try {
conn=DriverManager.getConnection(url,user,pass);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
rs=stmt.executeQuery(sql);
}
catch(SQLException e) {
System.err.println("SQL error:"+e.getMessage()+"\r\n"+sql);
}
return rs;
}public void executeUpdate(String sql) {
try {
conn=DriverManager.getConnection(url,user,pass);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
stmt.executeUpdate(sql);
}
catch(SQLException e) {
System.err.println("SQL error:"+e.getMessage()+"\r\n"+sql);
}
}
}