sdemo.java

来自「sdemo.zip」· Java 代码 · 共 43 行

import java.io.*;
import java.sql.*;
class SDemo 
{
	public static void main(String[] args) throws Exception
	{
		//String un="";
		//String pw="";
		DataInputStream din=new DataInputStream(System.in);
		System.out.println("Enter a Name:");
		String s=din.readLine();
		System.out.println("Enter password:");
		String p=din.readLine();
		//System.out.println(p);
		try{
        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); 
		Connection con=DriverManager.getConnection("jdbc:odbc:samp");
		String vsql="insert into stdlogin values('"+s+"','"+p+"')";
		
		Statement stmt=con.createStatement();
		stmt.executeUpdate(vsql);
		System.out.println("data inserted");
		//String vsql="select * from login";
		//String ss="create table stdlogin(username varchar(13), password varchar(20))";
		//Statement stmt=con.createStatement();
		//stmt.execute(ss);
		/*ResultSet rs=stmt.executeQuery(vsql);
		while(rs.next())
			{
          un=rs.getString(1);
		  pw=rs.getString(2);
			System.out.println("Username:"+un);
		System.out.println("password:"+pw);
			}*/
	    
		}
		catch(Exception e)
		{
			System.out.println(e);
		}
	}
}