package com.sjk.test;

import java.sql.Connection;

import java.sql.SQLException;

import java.sql.Statement;

import java.util.Scanner;

import com.shk.util.GetConnection;

public class Test1 {

public static void main(String[] args) {

Connection conn=null;

Statement stmt=null;

conn=GetConnection.getConn();

Scanner s=new Scanner(System.in);

System.out.println("请输入id:");

int id=s.nextInt();

System.out.println("请输入姓名:");

String name=s.next();

System.out.println("请输入年龄:");

int age=s.nextInt();

System.out.println("请输入性别:");

String sex=s.next();

//编写SQL语句

String sql="insert into stu(id,name,age,sex)"

+"values ("+id+",'"+name+"',"+age+",'"+sex+"');";

try {

//Statement对象用来执行sql

stmt=conn.createStatement();

} catch (SQLException e) {

e.printStackTrace();

}

try {

//执行sql

stmt.execute(sql);

} catch (SQLException e) {

e.printStackTrace();

}finally {

try {

conn.close();

} catch (SQLException e) {

e.printStackTrace();

}

try {

stmt.close();

} catch (SQLException e) {

e.printStackTrace();

}

}

}

}