java数据库连接sql_Java连接sql数据库



// Decompiled by Jad v1.5.8e2. Copyright 2001 Pavel Kouznetsov.

// Jad home page: http://kpdus.tripod.com/jad.html

// Decompiler options: packimports(3) fieldsfirst ansi space

// Source File Name:   ConnDB.java

package shopBeans;

import java.io.PrintStream;

import java.sql.*;

public class ConnDB

{

public Connection conn;

public Statement stmt;

public ResultSet rs;

private static String dbDriver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";

private static String dbUrl = "jdbc:sqlserver://127.0.0.1:1433;DatabaseName=ShopSystem";

private static String dbUser = "sa";

private static String dbPwd = "";

public ConnDB()

{

conn = null;

stmt = null;

rs = null;

}

public static Connection getConnection()

{

Connection connection = null;

try

{

Class.forName(dbDriver);

connection = DriverManager.getConnection(dbUrl, dbUser, dbPwd);

}

catch (Exception exception)

{

exception.printStackTrace();

}

if (connection == null)

System.err.println("警告:数据库连接失败!");

return connection;

}

public ResultSet doQuery(String s)

{

try

{

conn = getConnection();

stmt = conn.createStatement(1004, 1007);

rs = stmt.executeQuery(s);

}

catch (SQLException sqlexception)

{

sqlexception.printStackTrace();

}

return rs;

}

public int doUpdate(String s)

{

int i = 0;

try

{

conn = getConnection();

stmt = conn.createStatement(1004, 1007);

i = stmt.executeUpdate(s);

}

catch (SQLException sqlexception)

{

i = 0;

}

return i;

}

public void closeConnection()

{

try

{

if (rs != null)

rs.close();

}

catch (Exception exception)

{

exception.printStackTrace();

}

try

{

if (stmt != null)

stmt.close();

}

catch (Exception exception1)

{

exception1.printStackTrace();

}

try

{

if (conn != null)

conn.close();

}

catch (Exception exception2)

{

exception2.printStackTrace();

}

}

}