package JDBCDEMO;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class JdbcDemo {
/**
* @param args
*/
public static void main(String[] args) {
// TODO Auto-generated method stub
try {
/**
* 创建一个映射
*/
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
try {
Connection conn = DriverManager.getConnection(
"jdbc:mysql://localhost:3306/mytest?useUnicode=true&characterEncoding=utf8","root","root");
Statement ste = conn.createStatement();
ste.executeUpdate("insert into userinfo values(3,'按时','asd')");
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
try {
Connection conn2 = DriverManager.getConnection(
"jdbc:mysql://localhost:3306/mytest?useUnicode=true&characterEncoding=utf8","root","root");
Statement ste2 = conn2.createStatement();
ResultSet rt = ste2.executeQuery("select * from userinfo");
while(rt.next())
{
System.out.println("id = " + rt.getInt(1) + "sex = " + rt.getString(2));
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class JdbcDemo {
/**
* @param args
*/
public static void main(String[] args) {
// TODO Auto-generated method stub
try {
/**
* 创建一个映射
*/
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
try {
Connection conn = DriverManager.getConnection(
"jdbc:mysql://localhost:3306/mytest?useUnicode=true&characterEncoding=utf8","root","root");
Statement ste = conn.createStatement();
ste.executeUpdate("insert into userinfo values(3,'按时','asd')");
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
try {
Connection conn2 = DriverManager.getConnection(
"jdbc:mysql://localhost:3306/mytest?useUnicode=true&characterEncoding=utf8","root","root");
Statement ste2 = conn2.createStatement();
ResultSet rt = ste2.executeQuery("select * from userinfo");
while(rt.next())
{
System.out.println("id = " + rt.getInt(1) + "sex = " + rt.getString(2));
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}