mysql数据库实验报告jdbc_大三下软件项目开发实训第四天 - JDBC数据库增删改查...

讲解了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中国大陆许可协议 进行许可，转载必须注明作者和本文链接。

---