é¦å
éè¦è¿ä¸ªå
ï¼æ·»å å°å·¥ç¨ã ä¸é¢ç»ä½ 示ä¾ä»£ç import java.sql.*;public class SQLiteDemo { public static void main(String[] args){ try{ //è¿æ¥SQLiteçJDBC Class.forName("org.sqlite.JDBC"); //建ç«ä¸ä¸ªæ°æ®åºådata.dbçè¿æ¥ï¼å¦æä¸åå¨å°±å¨å½åç®å½ä¸åå»ºä¹ Connection conn = DriverManager.getConnection("jdbc:sqlite:data.db"); conn.setAutoCommit(false); Statement stat = conn.createStatement(); stat.executeUpdate( "create table if not exists tbl1 (name varchar(20), salary int);" );//å建ä¸ä¸ªè¡¨ï¼ä¸¤å stat.executeUpdate( "insert into tbl1 values('ZhangSan',8000);" ); //æå
¥æ°æ® stat.executeUpdate( "insert into tbl1 values('LiSi',7800);" ); stat.executeUpdate( "insert into tbl1 values('WangWu',5800);" ); stat.executeUpdate( "insert into tbl1 values('ZhaoLiu',9100);" ); ResultSet rs = stat.executeQuery("select * from tbl1;"); //æ¥è¯¢æ°æ® while (rs.next()) { //å°æ¥è¯¢å°çæ°æ®æå°åºæ¥ System.out.print("name = " + rs.getString("name") + " "); //åå±æ§ä¸ System.out.println("salary = " + rs.getString("salary")); //åå±æ§äº } rs.close(); conn.commit(); conn.close(); //ç»ææ°æ®åºçè¿æ¥ } catch( Exception e ) { e.printStackTrace ( ); } }}
温馨提示:答案为网友推荐,仅供参考