package com.chinasofti.se.homework0703;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class App2 {
private static final String URL = "jdbc:mysql://localhost:3306/数据库名?useUnicode=true&characterEncoding=utf8";
private static final String USER = "root";
private static final String PASSWORD = "root";
public static void main(String[] args) {
Connection conn = null;
try {
//加载驱动
Class.forName("com.mysql.jdbc.Driver");
//链接数据库
conn = DriverManager.getConnection(URL,USER,PASSWORD);
//创建Statement
Statement statement = conn.createStatement();
//执行SQL
boolean isResult = statement.execute("sql语句");
System.out.println(isResult);
ResultSet rs = statement.executeQuery("sql语句");
//解析结果
System.out.println("第一个字段名\t第二个字段名\t第三个字段名");
while(rs.next()){
String s = rs.getString(1);//第一个字段
long l = rs.getLong(2);//第二个字段
int i = rs.getInt(3);//第三个字段
System.out.println(s+"\t"+l+"\t"+i);
}
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}finally{
if(conn != null){
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
}
JDBC链接数据库
最新推荐文章于 2024-09-18 15:54:57 发布