jdbc连接数据库，并查询，调用存储方法

package SQL;


import java.awt.event.ActionEvent;
import java.sql.CallableStatement;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Connection;
import java.sql.Statement;
import java.util.Date;
import java.util.Scanner;


import javax.swing.JButton;
import javax.swing.JFrame;


public class SQL_STU {
static String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver"; // 加载JDBC驱动
// 连接服务器和数据库ServletUser
static String dbURL = "jdbc:sqlserver://localhost:1433; DatabaseName=STU"; 
static String userName = "151"; // 默认用户名
static String userPwd = "17"; // 密码


public void connSQL(){//判断是否与数据库连接
Connection conn = null;
try {
Class.forName(driverName);
conn = DriverManager.getConnection(dbURL, userName, userPwd);
System.out.println("Connection Successful!"); // 如果连接成功
} catch (Exception e) {
e.printStackTrace();
}finally{
//进行资源的释放
if(conn!=null){
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
public void showSP(){//将SP表全部记录输出
Connection conn = null;
try{//查询语句
Class.forName(driverName);
conn = DriverManager.getConnection(dbURL, userName, userPwd);
String query="SELECT * FROM SP";// 创造SQL语句
Statement stmt1 =conn.createStatement();// 执行SQL语句
ResultSet rs=stmt1.executeQuery(query);
System.out.println("SNO PNO BALANCE" );


while(rs.next()){
System.out.println(rs.getString("SNO")+rs.getString("PNO")+rs.getInt("BALANCE") );
}
System.out.println("查询数据成功");
rs.close();
stmt1.close();
conn.close();
}catch(Exception e){


e.printStackTrace();
}

}


public void showSPJ(){//将SPJ表全部记录输出
Connection conn = null;
try{//查询语句
Class.forName(driverName);
conn = DriverManager.getConnection(dbURL, userName, userPwd);
String query="SELECT * FROM SPJ";// 创造SQL语句
Statement stmt1 =conn.createStatement();// 执行SQL语句
ResultSet rs=stmt1.executeQuery(query);
System.out.println("SNO PNO JNO  QTY" );


while(rs.next()){
System.out.println(rs.getString("SNO")+rs.getString("PNO")+""+rs.getString("JNO")+" "+rs.getInt("QTY") );
}
System.out.println("查询数据成功");
rs.close();
stmt1.close();
conn.close();
}catch(Exception e){


e.printStackTrace();
}

}



public void showOrders(){//将Orders表的全部记录输出
Connection conn = null;
try{//查询语句
Class.forName(driverName);
conn = DriverManager.getConnection(dbURL, userName, userPwd);
String query="SELECT * FROM Orders";// 创造SQL语句
Statement stmt1 =conn.createStatement();// 执行SQL语句
ResultSet rs=stmt1.executeQuery(query);
System.out.println("ONE SNO PNO JNO         OTIME        QUANTITY" );


while(rs.next()){
System.out.println(rs.getString("ONE")+rs.getString("SNO")+rs.getString("PNO")+""+rs.getString("JNO")
+"     "+ rs.getDate("OTIME") +"       "+ rs.getInt("QUANTITY") );
}
System.out.println("查询数据成功");
rs.close();
stmt1.close();
conn.close();
}catch(Exception e){


e.printStackTrace();
}
}
public void PTransfer() throws SQLException{//调用存储过程 PTransfer，给Orders表输入数据
Connection conn = null;
        CallableStatement callStmt = null; 
      try {  
  Class.forName(driverName);
conn = DriverManager.getConnection(dbURL, userName, userPwd);


          // 存储过程 PTransfer 其实是向数据库插入一条数据  
          callStmt = conn.prepareCall("{call PTransfer(?,?,?,?,?)}");  
          // 参数index从1开始，依次 1,2,3...  
Scanner in = new Scanner(System.in);
System.out.println("请输入ONE");
String testONE = in.next();
callStmt.setString(1, testONE);

System.out.println("请输入SN0");
String testSNO = in.next();
callStmt.setString(2, testSNO);

System.out.println("请输入PN0");
String testPNO = in.next();
callStmt.setString(3, testPNO);

System.out.println("请输入JN0");
String testJNO = in.next();
callStmt.setString(4, testJNO);

System.out.println("请输入QUANTITY");
   int testQTY = in.nextInt();
callStmt.setInt(5, testQTY);
          


          callStmt.execute();  
          System.out.println("-------  Test End.");  
      } catch (Exception e) {  
          e.printStackTrace(System.out);  
      } finally {  
if (callStmt != null) {  
              callStmt.close();  
          }  
          if (conn != null) {  
              conn.close();  
          }  
      } 

}



public static void main(String[] args) throws SQLException {
SQL_STU sql = new SQL_STU();
sql.connSQL();
// sql.showOrders();
sql.showSP();
//创建gui 有5个文本框输入数据 三个文本框输出sp spj orders表 并有两个按钮 一个确定一个退出



}





}