怎样连接数据库！！需要注意什么

[zhanglongnian]

我的java基础不好，不会连接书库库，请多指教！！

[miaoliujun]

那就多看书吧，这样的例子多

[doctorNO1]

多看书
看书上的例子是怎么弄的
照着书上的例子打几遍代码熟练就好了

[chenkaili]

package com.accp.date;

import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;

public class Test {
public static void main(String[] args) {
try {
Class.forName("");
Connection co = DriverManager.getConnection("");
} catch (ClassNotFoundException e) {

e.printStackTrace();
} catch (SQLException e) {

e.printStackTrace();
}

}

}

[bayker]

类似的问题
看看这个
http://topic.csdn.net/u/20080721/17/5a5cc8f2-6c5d-443e-9dd8-dac1d439ed3d.html

[bayker]

同样，还应该设置数据源也就是ODBC里，同样重要

[flylovejings]

有直连和桥连之分
看你想知道那个
去网上搜个连接字符的方法

[wzm1983262]

public class ConnDB {

private static String url = "jdbc:odbc:netbar";
/* private static String url ="jdbc:sqlserver://localhost:1433;" +
"databaseName=NetBar;user=sa;password=uig1999";*/
private static Connection conn = null;
private static Statement st = null;
private static ResultSet rs = null;
public ConnDB() {
}
//桥连
public static Connection getConnection() {
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
} catch (ClassNotFoundException ex) {
}
try {
conn = DriverManager.getConnection(url);
} catch (SQLException ex1) {
}

return conn;
}

/* 直连
public static Connection getConnection() {
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
} catch (ClassNotFoundException ex) {
}
try {
conn = DriverManager.getConnection(url);
} catch (SQLException ex1) {
}

return conn;
}*/

public static ResultSet getResultSet(String sql) {
getConnection();
try {
st = conn.createStatement();
rs = st.executeQuery(sql);
} catch (SQLException ex1) {
ex1.printStackTrace();
}

return rs;
}

public static int execute(String sql) {
getConnection();
int a = 0;
try {
st = conn.createStatement();
a = st.executeUpdate(sql);
} catch (SQLException ex) {
ex.printStackTrace();
}
return a;
}

public static void CloseConnDB() {

try {
rs.close();
st.close();
conn.close();
} catch (SQLException ex) {
ex.printStackTrace();
}
}
}