Jdbc初体验

Java数据库连接(JDBC)由一组用 Java 编程语言编写的类和接口组成。JDBC 为工具/数据库开发人员提供了一个标准的 API,使他们能够用纯Java API 来编写数据库应用程序。然而各个开发商的接口并不完全相同,所以开发环境的变化会带来一定的配置变化。本文介绍的是连接SQLServer数据库:

1.打开SQLServer的配置管理器:

Jdbc初体验

2.打开TCP/IP的属性,IPALL的端口改为1433

Jdbc初体验

3.打开服务,重新启动SQL Server(SQLEXPRESS)

Jdbc初体验

4.下面开始写简易的JDBC:

String DRIVER = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
String URL = "jdbc:sqlserver://localhost:1433;DatabaseName=bookDB";
String USERNAME = "sa";
String PASSWORD = "1234";

 

 1 package com.ccec.jdbc;
 2 
 3 import java.beans.Statement;
 4 import java.sql.Connection;
 5 import java.sql.DriverManager;
 6 import java.sql.PreparedStatement;
 7 import java.sql.ResultSet;
 8 import java.sql.SQLException;
 9 
10 public class jdbc {
11     private static final String DRIVER = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
12     private static final String URL = "jdbc:sqlserver://localhost:1433;DatabaseName=bookDB";
13     private static final String USERNAME = "sa";
14     private static final String PASSWORD = "1234";
15 
16     public boolean login(String username, String password) {
17         Connection con = null;
18         PreparedStatement st = null;
19         ResultSet rs = null;
20 
21         try {
22             Class.forName(DRIVER);
23             con = DriverManager.getConnection(URL, USERNAME, PASSWORD);
24             String sql = "select userName,pwd from userInfo where userName=? and pwd=?";
25             st = con.prepareStatement(sql);
26             st.setString(1, username);
27             st.setString(2, password);
28             rs = st.executeQuery();
29 
30             if (rs.next()) {
31                 System.out.println(username);
32                 return true;
33             }
34         } catch (ClassNotFoundException e) {
35             // TODO Auto-generated catch block
36             e.printStackTrace();
37         } catch (SQLException e) {
38             // TODO Auto-generated catch block
39             e.printStackTrace();
40         } finally {
41             try {
42                 if (rs != null) {
43                     rs.close();
44                 }
45                 if (st != null) {
46                     st.close();
47                 }
48                 if (con != null) {
49                     con.close();
50                 }
51             } catch (SQLException e) {
52                 // TODO Auto-generated catch block
53                 e.printStackTrace();
54             }
55         }
56         return false;
57     }
58 }

 

Jdbc初体验,布布扣,bubuko.com

Jdbc初体验

上一篇:使用T4模板调用Sqlserver链接生成自己的模板


下一篇:分页SQL代码