查询数据库操作.txt

来自「因此本系统的目标就是让顾客方便快捷和满意的购物。为了达到这一目标」· 文本 代码 · 共 33 行

import java.sql.*;
/* 
* A simple example to demonstrate how to use JDBCs Statement
* The table Student used in the example
* is created with
* create table Student (
* Sno varchar(4), 
* Sname varchar(8), 
* Sage Int,
* Sadd varchar(20)
* constraint picture_primary_key_constraint primary key(Sno) )
*/
class QuerySample{
   public static void main(String args[])
{
     try{
      Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
        String url = "jdbc:sqlserver://localhost;databaseName=Student";
Connection conn = DriverMananger.getConnection(url, "MyUserName", "MyPWD")；
        Statement stmt = conn.createStatment();        
        ResultSet rs = stmt.executeQuery("SELECT * FROM Student");
        stmt.executeUpdate("INSERT INTO Student VALUES(‘5’,’Li’,20,’Guangzhou’)");
    stmt.exectUpdate("UPDATE Student SET Sadd=’Beijing’ WHERE Sno=’1’ ")；
        stmt.executeUpdate("DELETE FROM Student WHERE Sadd=’Beijing’ ");
        stmt.executeUpdate("ALTER TABLE ADD COLUMN Ssex VARCHAR(2) ");
        stmt.executeUpdate("DROP TABLE Student");
        conn.close();
}catch(SQLException e){
   e.printStack();
}
}
}