db.java

在线判作业系统

/*
 * DB.java
 *
 * Created on 2007年3月27日, 下午6:24
 *
 * To change this template, choose Tools | Template Manager
 * and open the template in the editor.
 */

package teachmanage.DB_management;


import java.sql.*;
import java.util.Hashtable;

/**
 *
 * @author CASE
 */
public class DB
{
      Connection conn = null;
      Statement statement = null;
      ResultSet rs = null;
      String username = "sa";
      String userpasswd = "sa";
      String dbname = "TeachManage";
      String table = "Student";

      /** Creates a new instance of DB */
      public DB()
      {
            String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=TeachManage";
            try
            {
                  Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
                  conn=DriverManager.getConnection(url,username,userpasswd);
                  statement = conn.createStatement();
            }
            catch(Exception ex)
            {
                  ex.printStackTrace();
            }

      }

      public void Insert(String strSQLID,Hashtable hash)
      {

      }

      public ResultSet search(String strsql)
      {
            try
            {
                  rs=statement.executeQuery(strsql);
            }
            catch(SQLException ex)
            {
                  ex.printStackTrace();
            }
            return rs;
      }

      public void execute(String strsql)
      {
            try
            {
                  statement.execute(strsql);
            }
            catch(SQLException ex)
            {
                  ex.printStackTrace();
            }
      }

      public void dbclose()
      {
            try
            {
                  rs.close();
                  statement.close();
                  conn.close();
            }
            catch(Exception ex)
            {
                  ex.printStackTrace();
            }
      }
      public static void main(String args[])
      {
         //   String sql="delete from stu_info where number='12'";
            String sql="insert into stu_info values('12','456','d','dfd')";
            String strsql="update stu_info set name='111',sex='111',department='111' where number='12'";
           DB test=new DB();
           try
           {
            test.execute(strsql);
           }catch(Exception e){};
      }

}