用java键盘输入插入mysql数据的语句
时间: 2024-02-25 08:54:14 浏览: 23
以下是用Java键盘输入插入MySQL数据的语句的示例代码:
```
import java.sql.*;
public class InsertData {
static final String JDBC_DRIVER = "com.mysql.jdbc.Driver";
static final String DB_URL = "jdbc:mysql://localhost/TEST";
static final String USER = "username";
static final String PASS = "password";
public static void main(String[] args) {
Connection conn = null;
Statement stmt = null;
try {
Class.forName(JDBC_DRIVER);
System.out.println("Connecting to database...");
conn = DriverManager.getConnection(DB_URL,USER,PASS);
System.out.println("Creating statement...");
stmt = conn.createStatement();
// 从键盘输入数据
Scanner scanner = new Scanner(System.in);
System.out.print("请输入姓名:");
String name = scanner.nextLine();
System.out.print("请输入年龄:");
int age = scanner.nextInt();
scanner.nextLine(); // 消耗掉nextInt()方法留下的回车符
System.out.print("请输入地址:");
String address = scanner.nextLine();
// 插入数据
String sql = "INSERT INTO Persons (name, age, address) " +
"VALUES ('" + name + "', " + age + ", '" + address + "')";
stmt.executeUpdate(sql);
System.out.println("数据已成功插入!");
stmt.close();
conn.close();
} catch(SQLException se) {
se.printStackTrace();
} catch(Exception e) {
e.printStackTrace();
} finally {
try {
if(stmt!=null) stmt.close();
} catch(SQLException se2) {
}
try {
if(conn!=null) conn.close();
} catch(SQLException se) {
se.printStackTrace();
}
}
}
}
```
请注意,此代码仅用于演示目的,实际代码应该使用PreparedStatement类来防止SQL注入攻击。