最近在学java,今天刚刚学会用jdbc驱动操作sqlserver数据库,编写了一个javabean,请大家多指点。
package com.stditbase.lisai.java.javabean;
import java.sql.*;
public class Dboperater {
private Connection dbCon=null;
private Statement sta=null;
public void Getconnection()
{
String sqldriver="com.microsoft.sqlserver.jdbc.SQLServerDriver";
String dbURL="jdbc:sqlserver://localhost:1433;DatabaseName=";
String userName="sa";
String userPwd="123456";
try{
Class.forName(sqldriver);
dbCon=DriverManager.getConnection(dbURL,userName,userPwd);
System.out.println("Connection successful!");
}catch(Exception e)
{
e.printStackTrace();
}
}
public ResultSet Query(String sql)
{
ResultSet Results=null;
this.Getconnection();
try{
sta=this.dbCon.createStatement();
Results=sta.executeQuery(sql);
System.out.println("Get Results!");
}catch(Exception e)
{
e.printStackTrace();
System.out.println(e.toString());
}finally{
try{
if(sta!=null) sta.close();
if(dbCon!=null) dbCon.close();
}catch(Exception e)
{
e.printStackTrace();
}
}
return Results;
}
public int Update(String sql)
{
int result=0;
this.Getconnection();
try{
sta=dbCon.createStatement();
result=sta.executeUpdate(sql);
}catch(Exception e)
{
e.printStackTrace();
}
finally
{
try{
if(sta!=null) sta.close();
if(dbCon!=null)dbCon.close();
}catch(Exception e)
{e.printStackTrace();}
}
return result;
}
}