1.向表中添加一條或多條記錄,然後在控制台輸出記錄總數
package JDBC;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
public class Dog {
public static void main(String[] args) {
Connection con = null;
Statement sta = null;
PreparedStatement pre = null;
ResultSet rs = null;
String name = "歐歐";
int health = 100;
int love = 90;
String strain = "哈士奇";
try {
//加載驅動
Class.forName("com.mysql.jdbc.Driver");
//建立連接配接
String url = "jdbc:mysql://localhost:3306/zoology?useUnicode=true&characterEncoding=utf-8";
String user = "root";
String password = "123135";
con = DriverManager.getConnection(url,user,password);
sta = con.createStatement();
StringBuffer sbuff = new StringBuffer(
"insert into zoo(name,health,love,strain) values('");
sbuff.append(name + "',");
sbuff.append(health + ",");
sbuff.append(love + ",'");
sbuff.append(strain + "')");
sta.execute(sbuff.toString());
System.out.println("插入資料成功!");
String sql = "select count(*) from zoo";
pre = con.prepareStatement(sql);
rs = pre.executeQuery(sql);
int sum = 0;
while(rs.next()) {
sum = rs.getInt(1);
}
System.out.println("記錄總數:"+sum);
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
}finally {
try {
if(sta!=null) {
sta.close();
}
if(con!=null) {
con.close();
}
} catch (Exception e2) {
// TODO: handle exception
e2.printStackTrace();
}
}
}
}
2.寵物主人根據控制台提示輸入使用者名和密碼,如果輸入正确,輸出:使用者登入成功!否則輸出:登入失敗!
package JDBC;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Scanner;
public class Master {
public static void main(String[] args) {
Connection con = null;
PreparedStatement ps = null;
ResultSet rs = null;
Scanner input = new Scanner(System.in);
System.out.println("請輸入使用者名和密碼:");
System.out.print("請輸入使用者名:");
String name = input.next();
System.out.print("請輸入密碼:");
String pass = input.next();
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
try {
con = DriverManager.getConnection("jdbc:mysql://localhost:3306/zoology?useUnicode=true&characterEncoding=UTF-8","root","123135");
ps = con.prepareStatement("select * from master where name=? and pass=?");
ps.setString(1, name);
ps.setString(2, pass);
rs = ps.executeQuery();
while(!rs.next()) {
System.out.println("對不起本世界隻提供小段和廉頗供主人玩耍!請重新選擇:");
System.out.print("請輸入使用者名:");
name = input.next();
System.out.print("請輸入密碼:");
pass = input.next();
ps.setString(1, name);
ps.setString(2, pass);
rs = ps.executeQuery();
}
if(name.equals("小段")&&pass.equals("123")) {
System.out.println("登入成功!歡迎來到小段世界!");
}else {
System.out.println("登入成功!歡迎來到廉頗世界!");
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
try {
if(rs!=null) {
rs.close();
}
if(ps!=null) {
ps.close();
}
if(con!=null) {
con.close();
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}