|
#2
hardes2007-07-10 15:42
我靠
我真不知道该怎么形容的,形形色色的数据库连接! 我看你的连接字符串是最有性格的了,哈哈！ 我看你按照前辈我这样的写发就行了,一般人我不告诉他！！ 乱78遭的东西我就不写了,代码你自己看看吧！！！ private static Connection conn = null; static { try { Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); }catch(Exception e) { } } public static Connection getConnection() { String url = "jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=数据库名"; String user = "sa"; String pwd = ""; try{ conn = DriverManager.getConnection(url,user,pwd); }catch(Exception e){} return conn; } public static void close() { if(conn!=null) { try { conn.close(); }catch(Exception e){} } } 你写的那些东西,理论上是没什么问题,但是你不觉得可读性太差了吗？ url = "jdbc:microsoft:sqlserver://"; serverName = "127.0.0.1"; portNumber = "1433"; databaseName = "test"; uid = "sa"; pwd = ""; 这些属性到是用了不少!根本没这必要啊！！ 最后还来个返回字符串的连接 return url + serverName + ":" + portNumber + ";databaseName=" + databaseName + ";"; 别这样写,有些变量少就少,实在少不鸟就没办法了,你每定义一个String类型的变量就得在你内存的堆中或者是常量池中创建一个类的对象实例,要资源开销的....好的变成习惯很重要哦！！！ [此贴子已经被作者于2007-7-10 16:33:57编辑过] |
学习struts阶段，数据库总是报错，在学校就没事，
错误信息：
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at db.DBHelper.getConnection(DBHelper.java:18)
at dao.DAOHelperUser.login(DAOHelperUser.java:19)
at action.UserAction.login(UserAction.java:26)
我的代码：
package db;
import java.sql.*;
public class DBHelper {
private static Connection conn = null;
private static String url = null;
private static String serverName = null;
private static String portNumber = null;
private static String databaseName = null;
private static String uid = null;
private static String pwd = null;
public DBHelper() {
try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
} catch (ClassNotFoundException ex) {
ex.printStackTrace();
}
}
private static String getConnectionUrl()
{
url = "jdbc:microsoft:sqlserver://";
serverName = "127.0.0.1";
portNumber = "1433";
databaseName = "test";
uid = "sa";
pwd = "";
return url + serverName + ":" + portNumber + ";databaseName=" + databaseName + ";";
}
public static Connection getConnection()
{
try {
conn = DriverManager.getConnection(getConnectionUrl(),uid,pwd);
} catch (SQLException ex) {
ex.printStackTrace();
}
if ( conn != null )
{
System.out.println("连接成功");
}
return conn;
}
}
总报错，在学校就没事。高手们帮看看阿。。
