FilesExpand file tree

 master

/

TemplateDemo.java

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

28 lines (20 loc) · 761 Bytes

 master

/

TemplateDemo.java

Copy path

Top

File metadata and controls

• Code
• Blame

28 lines (20 loc) · 761 Bytes

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

package chapter16;

import java.sql.SQLException;

/**

* 使用JDBC操作数据库

*/

public class TemplateDemo {

public static void main(String[] args) {

String url = "jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=UTF-8";

String user = "root";

String pwd = "root";

SimpleConnectionDataSource dataSource = new SimpleConnectionDataSource(url, user, pwd);

JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);

try {

jdbcTemplate.update("INSERT INTO t_message(name, email, msg, number) VALUES (?,?,?,?)",

"测试员", "tester@qq.com", "这是一条测试", 1);

} catch (SQLException e) {

e.printStackTrace();

}

}

}