consqlserver.java

丽婴房库存销售系统 描述：C/S构架

package src1;
 

import java.sql.*;
import javax.swing.*;
public class ConSqlServer{
                Connection conn=null;
                Statement stmt=null;
                
                ResultSet rs=null;
                String sql ;
                String query;
                String userName="sa";
                String passWord="";
        public ConSqlServer(){
                try{
                       Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
                       

                       
                }catch(java.lang.ClassNotFoundException e){
                        System.err.println("ClassNotFound:"+e.getMessage());
                }
        }
        public ConSqlServer(String sql){
        	this.sql = sql;
            try{
                   Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
                   

                   
            }catch(java.lang.ClassNotFoundException e){
                    System.err.println("ClassNotFound:"+e.getMessage());
            }
    }
    
 /** *//***************************************************
        *method name: executeQuery()
        *功能:执行查询操作
        *return value: ResultSet
        *2005-12-05
****************************************************/
        public ResultSet executeQuery(String query){
                try{
                       

                        conn=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=丽婴房2",userName,passWord);
                        stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
                        rs=stmt.executeQuery(query);
                }catch(SQLException ex){
                        System.err.println("Error1:"+ex.getMessage());
                        JOptionPane.showMessageDialog(null, ex.getMessage()+"\n请重新输入!");
                        
                        }
                return rs;
        }
/** *//***************************************************
         *method name: executeUpdate()
         *功能:执行更新操作
         *return value: int
         *2005-12-05
****************************************************/

        public int   executeUpdate(){
                int result=0;
                try{
                        conn=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=丽婴房2",userName,passWord);
                        stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
                        result=stmt.executeUpdate(sql);
                }catch(SQLException ex){
                	System.out.println("Error:"+ex.getMessage());
                	JOptionPane.showMessageDialog(null, ex.getMessage()+"\n请重新输入!");
                        result=0;
                        }
                return result;
        }
 /** *//***************************************************
        *method name: close()
        *功能:关闭数据库链接
        *return value:  void
        *2005-12-05
****************************************************/
       public void close(){
         try {
           if (rs != null) rs.close();
         }
         catch (Exception e){
           e.printStackTrace(System.err);
         }
         try {
           if (stmt != null) stmt.close();
         }
         catch (Exception e) {
           e.printStackTrace(System.err);
         }
         try {
           if (conn != null) {
             conn.close();
           }
         }
         catch (Exception e) {
           e.printStackTrace(System.err);
         }
       }

}