?? sqlhelper.java
字號(hào):
package dal;
import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.lang.ClassNotFoundException;
public class SQLHelper
{
private static final String DRIVER="com.microsoft.sqlserver.jdbc.SQLServerDriver";
private static final String URL="jdbc:sqlserver://localhost:1433;DatabaseName=Shop";
private static final String USER_NAME="likun";
private static final String USER_PWD="111111";
private static Connection conn=null;
//此方法用來(lái)獲取一個(gè)連接對(duì)象
public static Connection getConn()
{
try
{
Class.forName(DRIVER);
conn=DriverManager.getConnection(URL,USER_NAME,USER_PWD);
}
catch(ClassNotFoundException e)
{
System.out.println (e);
}
catch(SQLException e)
{
System.out.println (e);
}
finally
{
return conn;
}
}
//用于執(zhí)行一條SQL語(yǔ)句
//參數(shù):一個(gè)命令對(duì)象
//返回值:執(zhí)行成功,返回true,否則返回false
public static boolean executeUpdate(PreparedStatement ps)
{
boolean result=true;
try
{
int i=ps.executeUpdate();
if(i>0)
{
result=true;
}
else
{
result=false;
}
}
catch(SQLException e)
{
System.out.println (e);
}
finally
{
coloseConn();
}
return result;
}
//用于查詢一條記錄
//參數(shù):一個(gè)命令對(duì)象
//返回值:記錄集對(duì)象
public static ResultSet executeQuery(PreparedStatement ps)
{
ResultSet rs=null;
try
{
rs=ps.executeQuery();
}
catch(SQLException e)
{
System.out.println (e);
}
return rs;
}
//此方法用來(lái)關(guān)閉連接
public static void coloseConn()
{
try
{
if(conn!=null)
{
conn.close();
}
}
catch(SQLException e)
{
System.out.println (e);
}
}
}
?? 快捷鍵說(shuō)明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -