讲解了java如何连接操作数据库,需要mysql数据库连接的jar包,然后添加build path
/**
* Project Name: Java
* Package Name: com.train.jdbc
* File Name: jdbcTest.java
* Created on: 2016年5月26日 下午8:48:32
* Author: jtahstu Email:root@jtahstu.com
* Copyright (c) 2016, www.jtahstu.com , All Rights Reserved.
*/
package com.train.jdbc;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class jdbcTest {
public static void main(String[] args) {
// TODO Auto-generated method stub
try {
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://127.0.0.1/test?useUnicode=true&characterEncoding=utf-8";
String user = "jtahstu";
String pwd = user;
Connection con = DriverManager.getConnection(url, user, pwd);
Statement stat = con.createStatement();
String sql = "select * from stulist where 行政班 like '计算机13_'";
ResultSet rs = stat.executeQuery(sql);
int row = 0;
while (rs.next()) {
row++;
String numString = rs.getString("学号");
String nameString = rs.getString("姓名");
String sexString = rs.getString("性别");
System.out.println(numString + "\t" + nameString + "\t"
+ sexString);
}
System.out.println("共" + row + "位同学!");
} catch (Exception e) {
// TODO: handle exception
System.out.println(e.getMessage());
}
}
}
---
本文章采用 知识共享署名2.5中国大陆许可协议 进行许可,转载必须注明作者和本文链接。
---