java 连接数据库

//select.java
import java.sql.*;
public class cha{
public static void main(String args[]){
 Connection con;
 Statement sql;
 ResultSet rs;
try{
 Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
 }
catch(ClassNotFoundException e){
System.out.println(""+e);
}
try{
 con=DriverManager.getConnection("jdbc:odbc:mydb","","");
sql=con.createStatement();
rs=sql.executeQuery("select * from student order by num");
System.out.println("student:");
System.out.println("");
while(rs.next()){
 
System.out.println("学号:"+rs.getString(1));
System.out.println("姓名:"+rs.getString(2));
System.out.println("年龄:"+rs.getString(3));
System.out.println();
   }
con.close();
}
catch(SQLException el){System.out.println(""+el);}
 }
}

 

//insert.java
import java.sql.*;
public class zengjia{
public static void main(String args[]){
 Connection con;
 Statement sql; //声明Statement对象
 ResultSet rs;
 
try{
 Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
 }
catch(ClassNotFoundException e){
System.out.println(""+e);
}
try{
 Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
 }
catch(ClassNotFoundException e){
System.out.println(""+e);
}

//输入你要添加的学生信息
int num=1;                //学号 
String name="谭智泽";      //姓名
int age=10;                //年龄
try{
String sqls=null;
sqls="insert into student(num,name,age) values('"+num+"','"+name+"','"+age+"')";
con=DriverManager.getConnection("jdbc:odbc:mydb","","");
sql=con.createStatement();
sql.executeUpdate(sqls);

System.out.println("添加成功 ");
System.out.println("student:");
System.out.println();

rs=sql.executeQuery("select * from student order by num");
while(rs.next()){
 System.out.println("学号:"+rs.getString(1));
 System.out.println("姓名:"+rs.getString(2));
 System.out.println("年龄:"+rs.getString(3));
 System.out.println();
}

con.close();
}
catch(SQLException el){System.out.println(""+el);}
 }
}

 

//delete.java
import java.sql.*;
public class shanchu{
public static void main(String args[]){
 Connection con;
 Statement sql; 
 
try{
 Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
 }
catch(ClassNotFoundException e){
System.out.println(""+e);
}
try{
 Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
 }
catch(ClassNotFoundException e){
System.out.println(""+e);
}

//输入你要删除的学生信息
String num="1";  //学号
int b = Integer.parseInt(num);
try{
String sqls=null;
sqls="delete from student where num='"+b+"'";
con=DriverManager.getConnection("jdbc:odbc:mydb","","");
sql=con.createStatement();
sql.executeUpdate(sqls);

System.out.println("删除成功");
 con.close();
}
catch(SQLException el){System.out.println(""+el);}
 }
}

 

//update.java
import java.sql.*;
public class xiugai{
public static void main(String args[]){
 Connection con;
 Statement sql;
 
 
try{
 Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
 }
catch(ClassNotFoundException e){
System.out.println(""+e);
}
try{
 Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
 }
catch(ClassNotFoundException e){
System.out.println(""+e);
}

//输入你要修改的学生信息
String num="1";      //学号
int b = Integer.parseInt(num);
String name="谭智泽";  //姓名
int age=20;           //年龄
try{
String sqls=null;
sqls="update student set  name='"+name+"', age='"+age+"' where  num='"+b+"'";
con=DriverManager.getConnection("jdbc:odbc:mydb","","");
sql=con.createStatement();
sql.executeUpdate(sqls);

System.out.println("修改成功");
con.close();
}
catch(SQLException el){System.out.println(""+el);}
 }
}

推荐到鲜果： 查阅更多相关主题的帖子: 谭智泽 java 连接数据库