导包：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
    */
   publicstatic connectiongetconnection() {
      connectionconn = null;
      try {
         // 1. 加载驱动
         class.forname(net.sourceforge.jtds.jdbc.driver);
// 连接字符串jdbc:jtds:sqlserver://ip:端口/数据库名;
         final string url =jdbc:jtds:sqlserver://127.0.0.1:1433/superdogmall;
// 登陆数据库账号
         final string user =sa;
// 登陆数据库密码
         final string password =123456;
conn= drivermanager.getconnection(url, user, password);
      }catch(classnotfoundexception e) {
         e.printstacktrace();
      }catch(sqlexception e) {
         e.printstacktrace();
      }
return conn;
   }
publicstaticvoid main(string[] args) {
      system.out.println(dbutil.getconnection());
   }
}
部分建表和插入内容的sql语句：
use superdogmall
--建立表userinfo
create tableuserinfo
( useridvarchar(20)primarykey,
  userpassword varchar(20)notnull,
  username varchar(20),
  useremail varchar(40),
  userbirth datetime,
  useraddress varchar(40),
  usermoney int
)
select *fromuserinfo
insert intouserinfovalues('zhizunbao','123','至尊宝','zhizunbao@supermall.com','1980-10-10','四川省九寨沟',50000)
insert intouserinfovalues('ershixiong','123','二师兄','ershixiong@supermall.com','1981-11-14','山东省威海市',5000)
insert intouserinfovalues('zixiaxianzi','123','紫霞仙子','zixiaxianzi@supermall.com','1991-11-14','四川省盘丝洞',5800)
insert intouserinfovalues('niumowang','123','牛魔王','niumowang@supermall.com','1980-11-14','四川省牛头山',5100)
insert intouserinfovalues('tieshan','123','铁扇公主','tieshan@supermall.com','1988-11-14','新疆省火焰山',15000)
create tableproduct
(
  proid varchar(20)primarykey,
  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 *fromproduct
insert intoproductvalues('p_001','狗不理包子','食物','5','3000','1000','','好吃')
insert intoproductvalues('p_002','庆丰包子','食物','2','3000','1500','','好吃')
insert into product values('p_003','德园包子','食物','1','2000','1000','','好吃')
一些driver和url的写法：
oracle
driver=oracle.jdbc.driver.oracledriver
url=jdbc:oracle:thin:@localhost:1521:数据库名
sqlserver
driver=com.microsoft.jdbc.sqlserver.sqlserverdriver
url=jdbc:microsoft:sqlserver://localhost:1433;databasename=数据库名
mysql
driver=com.mysql.jdbc.driver
url=jdbc:mysql://localhost/数据库名?[后接参数]
db2
driver=com.ibm.db2.jdbc.app.db2driver
url=jdbc:db2://localhost:5000/数据库名
sybase
driver=com.sybase.jdbc.sybdriver
url=jdbc:sybase:tds:localhost:5007/数据库名