mysql,Access,sqlite数据库连接
Access数据库简单操作：public static Connection getConn() throws Exception {
Connection conn = null;
try {
Properties prop = new Properties();
prop.put("charSet", "gb2312");
String url = "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=D:\\WSYJ_first.mdb;useUnicode=false;characterEncoding=gbk";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn = DriverManager.getConnection(url, prop);
// new String(rs.getBytes("point_x"), "gbk"); 中文处理
Statement stmt1 = conn.createStatement();
ResultSet rs = stmt1.executeQuery("select * from CQWS_YY_PT order by objectid");
if (rs != null) {
while (rs.next()) {
String id = rs.getString("objectid");
String lon = rs.getString("point_x");
String lat = rs.getString("point_y");
System.out.println(id+"\t"+lon + "\t" + lat);
}
}
} catch (Exception ex) {
ex.printStackTrace();
}
return conn;
}
Mysql数据库简单操作:
public static Connection getConn() {
Connection conn = null;
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
// System.out.println("数据库驱动");
String url = "jdbc:mysql://localhost:3306/gpsoffset";
String user = "root";
String password = "root";
conn = (Connection) DriverManager
.getConnection(url, user, password);
System.out.println("连接成功");
} catch (Exception e) {
e.printStackTrace();
// System.out.println("连接失败");
}
return conn;
}
Sqlite数据库简单操作:
package com.wb.sqlite;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
public class Test {
public static void main(String[] args) throws Exception {
Class.forName("org.sqlite.JDBC");
Connection conn = DriverManager.getConnection("jdbc:sqlite:person.db");
Statement stat = conn.createStatement();
stat.executeUpdate("drop table if exists people;");
stat.executeUpdate("create table people (name, occupation);");
PreparedStatement prep = conn
.prepareStatement("insert into people values (?, ?);");
prep.setString(1, "Gandhi");
prep.setString(2, "politics");
prep.addBatch();
prep.setString(1, "Turing");
prep.setString(2, "computers");
prep.addBatch();
prep.setString(1, "Wittgenstein");
prep.setString(2, "smartypants");
prep.addBatch();
conn.setAutoCommit(false);
prep.executeBatch();
conn.setAutoCommit(true);
ResultSet rs = stat.executeQuery("select * from people;");
while (rs.next()) {
System.out.println("name = " + rs.getString("name"));
System.out.println("job = " + rs.getString("occupation"));
}
rs.close();
conn.close();
}
}
页:
[1]