jts连接数据库及部分SQL语句

导包：jtds-1.2.2.jar public class DBUtil { /** * 获得数据库连接 * @return */ public static ConnectiongetConnection() { Connectionconn = null ; try { // 1. 加载驱动 Class. forName ( net.sourceforge.jtds.jdbc.Driver ); // 连接字符串 jdbc:jtd导包：jtds-1.2.2.jar publicclassDBUtil {/***获得数据库连接*@return*/ publicstaticConnectiongetConnection() {Connectionconn =null;try{// 1.加载驱动Class.forName("net.sourceforge.jtds.jdbc.Driver");//连接字符串"jdbc:jtds:sqlserver://IP:端口/数据库名";finalString url ="jdbc:jtds:sqlserver://127.0.0.1:1433/SuperDogMall";//登陆数据库账号finalString user ="sa";//登陆数据库密码finalString password ="123456";conn= DriverManager.getConnection(url, user, password);}catch(ClassNotFoundException e) {e.printStackTrace();}catch(SQLException e) {e.printStackTrace();}returnconn;}publicstaticvoidmain(String[] args) {System.out.println(DBUtil.getConnection());}}部分建表和插入内容的SQL语句：use SuperDogMall--建立表userinfo create table userinfo (userId varchar (20) primary key,userPassword varchar (20) not null,userName varchar (20),userEmail varchar (40),userBirth datetime,userAddress varchar (40),userMoney int) select*from userinfo insert into userinfo values ('zhizunbao','123','至尊宝','zhizunbao@supermall.com','1980-10-10','四川省九寨沟',50000) insert into userinfo values ('ershixiong','123','二师兄','ershixiong@supermall.com','1981-11-14','山东省威海市',5000) insert into userinfo values ('zixiaxianzi','123','紫霞仙子','zixiaxianzi@supermall.com','1991-11-14','四川省盘丝洞',5800) insert into userinfo values ('niumowang','123','牛魔王','niumowang@supermall.com','1980-11-14','四川省牛头山',5100) insert into userinfo values ('tieshan','123','铁扇公主','tieshan@supermall.com','1988-11-14','新疆省火焰山',15000) create table product (proId varchar (20) primary key,proName varchar (20),proType varchar (20),proPrice float check (proPrice>=0),proStore int check (proStore>=0),proSales int check (proSales>=0),proPicture varchar (60),proDesc varchar (200)) select*from product insert into product values ('p_001','狗不理包子','食物','5','3000','1000','','好吃') insert into product values ('p_002','庆丰包子','食物','2','3000','1500','','好吃') insert into product values ('p_003','德园包子','食物','1','2000','1000','','好吃')一些driver和url的写法：oracledriver="oracle.jdbc.driver.OracleDriver"url="jdbc:oracle:thin:@localhost:1521:数据库名"sqlserverdriver="com.microsoft.jdbc.sqlserver.SQLServerDriver"url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=数据库名"mysqldriver="com.mysql.jdbc.Driver"url="jdbc:mysql://localhost/数据库名?[后接参数]"db2driver="com.ibm.db2.jdbc.app.DB2Driver"url="jdbc:db2://localhost:5000/数据库名"sybasedriver="com.sybase.jdbc.SybDriver"url="jdbc:sybase:Tds:localhost:5007/数据库名"